Finding most recent Duplicates?

[SikSlk]

Hi, been searching this forum for a couple of months now im working with access and up till now i have solved most of my problems

Ok the problem.

For the purpose of the question I have a training database:
running one table with user id and user name.
another for job id and job name.
Another for training table with an autonumber, user id, job id, and date

Id like to build a query which bought up the newest only for each user id and job id.

eg.
UI JI Date
2 5 01/05/05
2 5 01/05/06
3 5 01/05/05
3 6 01/05/05
4 6 01/05/06

to
UI JI Date
2 5 01/05/06
3 5 01/05/05
3 6 01/05/05
4 6 01/05/06

Iv tried using a few different ways of using duplicate queryies etc, but im just too newb to figure it out

Any suggestions or help would be appreciated.
Thanks

 

[NigelBrown]

Hehe, may have a solution for you.

Create two new queries with only Job_id and date, and only user_id and date.

Job_id and user_id should be 'group by' on the grid Totals row and date should be 'Max' on the grid Totals row. This will pick out the last date per job/user in each query then you can incorporate in other queries/reports.

 

[SikSlk]

Thanks for the Idea! I'm going to have a quick stab at it now before i go home. Will post back maybe tomorrow of my success (or death from stupidity )

Thanks again

 

[SikSlk]

Fixed me up good... didn't even know about that stuff

Thanks for that again