Query to change all data

[justinwright]

Oh wow!! I feel like such a retard now... lol



Thank you so much!

One more thing, and I'll stop bugging you so incessantly. Is there a way to make the month show in all caps? I'm not sure how it will play with older programs (DOS-based) with lowercase characters, so I'd rather be on the safe side

[weekend00]

use Ucase:

myDateChangeQuery = "UPDATE TemporaryList set [DESC]=ucase(Format(DateAdd('m',1,Now),'MMMM '))+[DESC]"

[justinwright]

Perfect! Thank you so much for all of your help!

[weekend00]

my pleasure.