O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Fri Dec 2 16:01:10 CST 2005
Thanks Marty and Gustav I wound up changing the query to a UNION query so the where statement was divided between the two portions and it works. I am still going to try upgrading all of Access97 so it is good. Then I am going to make sure Access 2000 is correct. This is what I get from computer updating by our "special" computer unit without me watching step by step. Hope you both have a good weekend Thanks Patti ****************************************************************** *Patricia O'Connor *Associate Computer Programmer Analyst *OTDA - BDMA *(W) mailto:Patricia.O'Connor at otda.state.ny.us *(w) mailto:aa1160 at otda.state.ny.us ****************************************************************** -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.