sorting out of order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I need to sort a report by a Date column a Door# column and a Stop# column
in this order. My problem is that if the Stop# = 2 or higher I need it to
group with the Door column in the middle of the Date column sorting. For
example:

Date Door Stop
02/01/06 321 1
02/03/06 202 1
02/07/06 127 1
02/09/06 221 1

02/20/06 130 1
02/03/06 130 2

02/25/06 325 1
03/05/06 250 1

Can this be done?

Thanks,

Cage
 
Hi all,

I need to sort a report by a Date column a Door# column and a Stop# column
in this order. My problem is that if the Stop# = 2 or higher I need it to
group with the Door column in the middle of the Date column sorting. For
example:

Date Door Stop
02/01/06 321 1
02/03/06 202 1
02/07/06 127 1
02/09/06 221 1

02/20/06 130 1
02/03/06 130 2

02/25/06 325 1
03/05/06 250 1

Can this be done?
Click to expand...

I'm sorry... I've read this three times and I don't understand what you want.
What do you mean by "in the middle of the Date column sorting"?

The example appears to be sorted by date and by stop. The first block is not
sorted by door (but doesn't have any cases with multiple records on a date).

Could you explain?

John W. Vinson [MVP]
 
Back
Top