urgent help needed with a query for last date in Access

[Richie]

Hi, I've set up a training company recently and I really need help to track my documents so here goes.

I have set up a table called "Review Tracking":
Primary Key is the REVIEWID
CandidateID is linked on a "one to many" relationship from the "Personal Information" table

Within the "Review Tracking" table, I have a series of fields with dates:
Review 1 complete
Review 2 complete
Review 3 complete
Review 4 complete etc.



So I need a query that will bring up the latest date from the "review complete" fields. i.e. For each candidate, I need to know the date of the last review submitted.

First Name (from personal details table), Surname (from personal details table), date of last document submitted (from Review Tracking table)

Any help would be genuinely appreciated

Many thanks in advance
Rich

[pbaldy]

If those are fields, your design is not normalized. I'd have a related table with a record for each review. That said:

Minimum or Maximum Value Across Fields of Record

[Richie]

Hi Paul

You're a genius! thank you

[pbaldy]

Happy to help, and welcome to the site!