Counter - on Date in order of occurrence for each group

  • Thread starter Thread starter Sharleen Riley
  • Start date Start date
S

Sharleen Riley

The dates and the counter must stay in date order and
then restart with the new employee

Jim

Ticket Country Date Counter
12 US 2/10/2003 2
13 US 2/11/2003 3
14 US 2/12/2003 4
15 US 2/13/2003 5
16 US 2/1/2003 1

Mary

Ticket Country Date Counter
17 US 3/10/2003 2
11 US 3/11/2003 3
10 US 3/12/2003 4
09 US 4/13/2003 5
59 US 3/1/2003 1

Any suggestions?
 
You may need to use a subquery in your report's record source. I thought you
had some order but a second glance suggests you don't have any values that
define the order of the records so this is impossible.
 
Back
Top