Combine query results

[broadm]

Hi. I am quite new to access so please bear with me. The scenario is that I am trying to design a databse for nvq assessment. within that there is reviews. each candidate as a review which is listed in table eg.

review id candidate_id date of review
1 mr a 01/01/11


2 mr b 01/01/11
3 mr c 01/01/11
4 mr a 02/02/11
5 mr b 02/02/11
6 mr c 02/02/11

with the canidate being linked to a candidate.

what i want is to have another list that only picks up the last date or review id for each person which would give

review id candidate_id date of review
4 mr a 02/02/11
5 mr b 02/02/11
6 mr c 02/02/11

Thanks

[orange]

I have no idea what a "nvq assessment" is.

Perhaps you could elaborate on what you're trying to accomplish and also show us
-what you have tried, and
- the structure of your tables.

[Rixxe]

I would look into the MAX() function, and GROUP BY function.

http://www.techonthenet.com/sql/max.php

If you get stuck come back, and im sure someone will be able to help you out.

Good Luck.



Edit: Orange is quicker