[nreel]

Hi Nitecat,

Sorry about the gender comment. I usually keep it neutral but I see I slipped in that last sentence. I almost made it...LOL.

I kind of figured you weren't seeing the file extension names. So, I'm glad my directions worked out.

MSAccess has two Tool Icons to perform a SORT. They are side by side with one icon having a letter A above the letter Z with Down Arrow and the tool tip says SORT ASCENDING. The other Icon is just the opposite with letter Z on top of the letter A with the tool tip saying SORT DESCENDING.

Since the Icons were showing letters and could be used to sort any column, whether or not the column was Numeric, Alpha/Numeric, or Text, I just called it an Alpha Sort.

Yes, adding leading ZEROS is quite tricky when performing a REPLACE function. You want to add 3 Leading ZEROS to all Book Ids from 1 to 10, but you don't want to add 3 Leading Zeros to Book Ids from 100 to 1000, which start with a 1, and so on.

But, if you take the time to get all the Leading ZEROS in the right place, sorting the Book ID column will prove invaluable.

Q1. First, I do not use the MTU SongBook Feature to print my SongLists. However, I think, in your case, you will be OK with your newly printed SongBooks and should not affect your show. It is true that some BRANDS have changed, but the BRAND, if you chose to list them in your SongLists, are only for the Singer's convenience. These BRAND Prefixes have nothing to do with you running your show because you will only be interested in the Book ID Numbers that the Singers give you.

If any BRAND is different upon re-importing, then, this will straighten itself out upon the next Complete SONGBOOK printing that you will, eventually, do.

What you see, when operating Hoster at a show, compared to what the Singer sees in your newly printed SongBooks, will not be in conflict if you run into the situation of a BRAND change. Because, again, you are only concerned with the Book ID numbers...not the BRAND.

You will be the only one to know the difference. For instance, and, I'm not sure what may have changed, but, for example, if the Previous designation for POP HITS ROCK 0410 was PHR0410, and, is listed in your new SongBooks that way, with Book ID 102, now becomes POP HITS MONTHY ROCK 0410 with a designation of PHMR0410, with Book ID 102, you will be the only one to know anything has changed. You will have, still, assigned and IMPORTED this disc on the ORIGINAL Book ID…So, no harm.

My New Year wish is that you will be successful with all your shows using Hoster.

Again, if you want me to straighten out your Songs.MDB by adding ZEROS where needed, just say the word. I've done this several times over the past year and a half that I've been using Hoster and I have become quite proficient.

Norm