I have a query which takes data from 3 tables: Errors, Employees on
work stations, Employees. In our company we have a production line and
every employee has one-week assignment- e.g. on station AM, then
another week on station AN etc. Query connects errors with employees
and we have a briefly view on the situation. I used the function DMax
to have less work with assignments- we want to do it every Monday for
a whole week. But when i have different dates in fields 'Dates' from
table 'Employees on ...' the query shows only errors with the last
date, not the everyone. Do somebody know how can i define the criteria
for every employee- so the function DMax will find the last date for
every employee's ID not the last date in the whole table?