[Nitecat]

Norm,


I now have Access. Purchased the upgrade version last night and loaded it. All fine there. I can now open the songs.mdb file and have done the sort on Book ID. I really do think it would be much easier if they sorted correctly (with those leading zeros in place). Can you give me instructions on how to do the replace on these to get the zeros as they should be or is it too complicated? I hate to have you spend any more time working on this than you already are now with all of your wonderfully detailed posts. I certainly do appreciate the personal attention you are giving me with my problem. I hope MTU appreciates users such as yourself.

I assume that once I get this file into a useable Book ID order, I can widen columns to see all in the field and hide columns I don't care to see (can I delete them?), then print the file. When I have both my original songs.mdb file and the new songs.mdb file with the 38 gigs of songs I had backed up printed out, then I will manually compare the two printouts line by line and determine what I need to reload and what Book IDs to use, etc. Does this sound correct?

Will wait to hear from you before I do anything more on my end. Thanks. Ruth (Nitecat)