Sorting a crosstab query

  • Thread starter Thread starter Maggie
  • Start date Start date
M

Maggie

I have a crosstab query that contains the following column

Client name
2003 client signed date
2004 client signed date

The query sorts the client signed field by year and
populates the date in the correct year column.

A client could have a date in 2003 and/or 2004.

I would like to sort based date but when I sort the 2003
column all the nulls go first which means that they didn't
get a sign-off until 2004.

Any ideas on how to sort on the 2003 column and make the
nulls not come up first. Also once I get the 2003 column
I would like to sort the 2004 column.

Thanks,

maggie
 
Sorting is usually done in a report. You should be able to enter an
expression in the grouping level of:
=Nz([2003 client signed date],#12/31/2020#)
 
Back
Top