Argh!

Access update: I'm still fighting with it. These are the annoying little issues that seem like they should be so simple, and yet take hours to figure out.

So far I've:
Searched in Google
Searched in manuals
Searched the MS Access Help file
Asked an MS Access trainer
Asked a data analyst at Partners Health Care
Asked an IS person at Partners Health Care
Asked an old co-worker from THP
Asked a random stranger who found my LJ I'm guessing from someone on his friend's list.

This is just silly! It shouldn't be so difficult to change a text variable to a date.