P
Pablo Da Podge
Using Access 2000:
Holding training records for several hundred people as part of a more
detailed database, Training Record contains an AutoNumber primary key, Staff
ID which is repeated for each type of course and for annual or 3 yearly
requalification (depending upon course), Course Type,Status (Pass, Fail,
Booked) and Pass Date.
I need to select only the most recent passes in each subject for each person
to list forthcoming retraining needs, using Pass Date plus 365 days or
whatever. i.e. There is no point in showing a 2003 pass that would need to be
redone on 2004, when the 2004 pass is already there and showing when the 2005
course should be due.
To make the arrangement of forward planning of courses easy and part
automated I do not want to rely on holding only the last Pass in the table,
i.e re-dating the old record.
I cannot find a way to select these most recent items only for each person
as required.
HELP!!!!!!
Holding training records for several hundred people as part of a more
detailed database, Training Record contains an AutoNumber primary key, Staff
ID which is repeated for each type of course and for annual or 3 yearly
requalification (depending upon course), Course Type,Status (Pass, Fail,
Booked) and Pass Date.
I need to select only the most recent passes in each subject for each person
to list forthcoming retraining needs, using Pass Date plus 365 days or
whatever. i.e. There is no point in showing a 2003 pass that would need to be
redone on 2004, when the 2004 pass is already there and showing when the 2005
course should be due.
To make the arrangement of forward planning of courses easy and part
automated I do not want to rely on holding only the last Pass in the table,
i.e re-dating the old record.
I cannot find a way to select these most recent items only for each person
as required.
HELP!!!!!!