Sorts / Grouping and duplicates!

[wonderlander]

Application uses any of the following back ends : SQL, Access and Oracle

Data is stored as such

Date   Employee    Job Number
1/1/04 Ted Smith   123
1/1/04 Paul Taylor 123
2/1/04 Paul Taylor 123
2/1/04 Bob Little  87
2/1/04 Jamie Bent  223
3/1/04 Jamie Bent  223
1/1/04 David Grant 56
1/1/04 Bob Little  87
2/1/04 Ted Smith   123

I want the report to print out in Job Start Date and then by Job Number. The output from the data above should give:

1/1/04 Job 56
1/1/04 Job 87
1/1/04 Job 123
2/1/04 Job 223


If I Group by date then I get the job number on every day it appears...hope that makes sense!

 

[MColeman]

with the data:

1/1/2004 job1
2/1/2004 job1
3/1/2004 job1
1/1/2004 job2
1/1/2004 job3

1. Group by Job
2. Top N 1 sort on date (unchecked include others)

and got

01/01/2004
job1 01/01/2004
job2 01/01/2004
job3 01/01/2004

Is this what you needed the output to look like?

 

[wonderlander]

Seems perfect to me...thanks for the speedy reply!