Null Values

[Guest]

In a SQL query is there a way to sort my records in decending order by date
but still keep the records with a null date at the beginning of the results?
We have contracts in order by the effective date. I am pulling the most
current contract but they don't get an effective date until all signatures
are received so the date will be null.

Thanks in advance,

Suzie

 

[Ken Snell [MVP]]

Add a calculated field to the query:
SortField: Nz([RecordDate], Date()+100)

Then sort descending on SortField.

 

[Guest]

So simple! Thanks a bunch!

Add a calculated field to the query:
SortField: Nz([RecordDate], Date()+100)

Then sort descending on SortField.

--

Ken Snell
<MS ACCESS MVP>

In a SQL query is there a way to sort my records in decending order by
date
but still keep the records with a null date at the beginning of the
results?
We have contracts in order by the effective date. I am pulling the most
current contract but they don't get an effective date until all signatures
are received so the date will be null.

Thanks in advance,

Suzie