MS Access 97, MS Windows NT 4.00.1381
OK- Annual TB compliance- some employees get skin tests, some complete a questionnaire. I have a raw text file in which skin tests and questionnaires are seperate columns.
I work in the clinic, and I need to forward everyone’s latest compliance date to HR, which is not allowed to know if an employee gets the skin test or questionnaire. So I need a query that will look at the Skin Test field and Questionnaire field, check which date is more recent, and put that more recent date into a new TB Compliance Date field.
Name Skin Test Date Questionnaire date McClure, Troy 06/12/2002 07/29/2004 Adams, Cecil 08/01/2004 11/22/2003
…needs to yield…
Name Last TB Date McClure, Troy 07/29/2004 Adams, Cecil 08/01/2004
Any help would be greatly appreciated.