Struggling to use DMax for dates

[ande8698!]

I am performing a query involving two tables. The first table has fields including: last name, first name, and Site ID. The second table has last name, first name, site id, and date reported. The second table also has multiple records for the person and site id, with different dates for the "date reported" field. When I run my query, I am specifying criteria for last name, first name, and site id, but I would like to use DMax to show only the most recent date reported. Any help in this task would be greatly appreciated.



THanks

[June7]

You want max date for each name/site ID pair?

SELECT LastName, FirstName, SiteID, Max(DateReported) AS MaxDate FROM Tablename GROUP BY LastName, FirstName, SiteID;

Or build a report using Sorting & Grouping features with aggregate calcs in footer sections.

Why are you saving duplicate data? Instead of saving name and SiteID in second table, just save the primary key of table 1 records.