Hi,
I have a query that looks like this:
PatientID LastVisit LastMed LastVaccine
1001 1/1/2004 3/1/2004 10/1/2004
1002 10/1/2005 3/1/2004 10/1/2004
.....
I need a calculated field (let's call it LastActivity) that contains
the maximum of LastVisit, LastMed, and LastVaccine. Thus, lastActivity
should be 10/1/2004 for the first record and 10/1/2005 for the second
record in the example above. Any ideas?
Thanks,