Thanks a lot for all your posts, everybody! I learned a lot by reading them. I especially liked Jeff's suggestion about how to get rid of my huge case...

Thanks for all the suggestions, everyone. The query below uses a case expression to get the time in am/pm format and then converts that to datetime. This is...

Thank you for all the responses, everybody. I am going to try to use Microsoft Access to read the tables I need (I'll use an ODBC connection to the...

I am not calling a stored procedure in my query. (I don't think I can call any stored procedures from the data base.) I just want to rewrite...