Can someone explain "Dmax"

G

G

Can someone explain how to use the dmax in the query grid criteria line?

I'm interested in getting the max date for an employee, where the employee
id matches the employee id in the same table.

I then need to do a separate query with a primary table, where the employee
date = the max of the date in the above paragraph.

What's the syntax or best way to do this?
 
O

Ofer

You don't need to create a query with DMAX, just use a group by query, with
max on the date

SELECT DISTINCTROW MyTable.EmployeeNum, Max(MyTable.DateField) AS MaxDateField
FROM MyTable
GROUP BY MyTable.EmployeeNum
 
Top