G
GATChW
Hi,
I have two tables - 'staff' and 'appraisals'. The 'staff' table holds basic
employee information, the 'appraisal' table holds dates of appraisal meetings
and comments for that appraisal.
I’d like to create a query that shows me all the staff information for all
members of staff (who have at least one entry in the appraisal table)
together with the information for their latest appraisal (latest by the date
held in the ‘appraisal’ table).
I found it relatively simple to create a query that shows the information
for every entry in the ‘appraisal’ table, but limiting it to just the latest
has beaten me!
A simplified table structure:
STAFF
st_id, st_name, st_location, st_post
APPRAISAL
ap_id, ap_st_id, ap_date, ap_comment
As you can no doubt tell, the table relationship is based on st_id/ap_st_id.
Thanks in advance for any help that you can offer.
I have two tables - 'staff' and 'appraisals'. The 'staff' table holds basic
employee information, the 'appraisal' table holds dates of appraisal meetings
and comments for that appraisal.
I’d like to create a query that shows me all the staff information for all
members of staff (who have at least one entry in the appraisal table)
together with the information for their latest appraisal (latest by the date
held in the ‘appraisal’ table).
I found it relatively simple to create a query that shows the information
for every entry in the ‘appraisal’ table, but limiting it to just the latest
has beaten me!
A simplified table structure:
STAFF
st_id, st_name, st_location, st_post
APPRAISAL
ap_id, ap_st_id, ap_date, ap_comment
As you can no doubt tell, the table relationship is based on st_id/ap_st_id.
Thanks in advance for any help that you can offer.