Problems with sorting

[Sue]

I have 3 date fields. For convenience, I'll call them A, B, & C. They're all
in mm/dd/yyyy format. I want to sort them in this fashion:

C should be in descending order.
If C is null, the secondary sort should be in descending order by B.
If B is null, the tertiary sort should be in descending order by B.

I simply can't get it to sort correctly.

Ideas?

Thanks.

 

[Allen Browne]

Try something like this in the ORDER BY clause of your query:
IIf([C] Is Null, IIf( Is Null, [A], ,), [C])

 

[Sue]

PERFECT!
Thanks.
--
Thanks for your time!

Try something like this in the ORDER BY clause of your query:
IIf([C] Is Null, IIf( Is Null, [A], ,), [C])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have 3 date fields. For convenience, I'll call them A, B, & C. They're
all
in mm/dd/yyyy format. I want to sort them in this fashion:

C should be in descending order.
If C is null, the secondary sort should be in descending order by B.
If B is null, the tertiary sort should be in descending order by B.

I simply can't get it to sort correctly.

Ideas?

Thanks.