date query

[Saylindara]

My database contains a list of employee courses.
Each course will have an update frequency, e.g. never, 1 year, 2 years etc.
I know how to build a query which will show when a course is overdue for
update but how do I make it so that only the last time that course was taken
is shown as overdue.
For example Course A has to be updated annually so the employee's record for
that course could read:

Course A 23/11/06
Course A 4/12/07
Course A 12/1/08

I only want the query to show the 12/1/08 entry as being overdue, bearing in
mind there will be lots of other courses listed which will have different
update frequencies and I want the query to show all the courses due for
update.

 

[Noëlla Gabriël]

Hi,

you need to make a group query to get only the max date per employee per
course.
Just make the query and click the totals button (the sommation sign). In the
extra totals lign you get you choose"Group by" for the employee and course
field and max for the date field. This way you only get the lasr date for
each employee and course.

Hope this helped

 

[Saylindara]

I'll try that. Thanks very much for your help.

Hi,

you need to make a group query to get only the max date per employee per
course.
Just make the query and click the totals button (the sommation sign). In the
extra totals lign you get you choose"Group by" for the employee and course
field and max for the date field. This way you only get the lasr date for
each employee and course.

Hope this helped