sort date ascending, if null value sort descending

S

Swimgirl

I need to sort ascending in a report as follows: Group by bank then sort by
date. The crux is if the date is null then place the null date at the end of
the bank group.
 
D

DebbieG

In the Sorting and Grouping dialog box, replace your date field with

=IIf([YourDateField] Is Null,1,0)

HTH,
Debbie


|I need to sort ascending in a report as follows: Group by bank then sort by
| date. The crux is if the date is null then place the null date at the end of
| the bank group.
 
S

Steve Schapel

Swimgirl,

You can use an expression like this to sort on...
IIf(IsNull([YourDateField]),99999,[YourDateField])

This can be done in the query that the report is based on, or in the
Sorting & Grouping dialog of the report design.
 
Top