I don't think your second method is correct. You are looking for the lowest number in the first gap, correct? In that case you'll either have to add an ORDER...

A long time ago, Steve wrote:

"Case Sensitivity is good for data quality. It ensures that names are entered correctly."

I'd like to disagree with this statement. Case sensitivity in no...

You say:

"Now you'd think...really...that it would make sense to delete the files first, then do the backup?"

I would say that that would absolutely make no sense at all, and I...

Advanced H&P here. I started out 20 years ago on my first computer with one finger. By now I use two fingers on each hand for the letters, thumbs...

Every program can be shortened by at least one statement and contains at least one bug, from which - by induction - one can deduce that each program can be...

... the first thing you do on a new Windows installation is going into the Regional Settings to change the date format to yyyy-mm-dd

Jeremy