sorting out of order

[cage4000]

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

 

[John W. Vinson]

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?

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]