Null Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Add a calculated field to the query:
SortField: Nz([RecordDate], Date()+100)

Then sort descending on SortField.
 
So simple! Thanks a bunch!

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

Then sort descending on SortField.

--

Ken Snell
<MS ACCESS MVP>

Suzie Raboin said:
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
Click to expand...
Click to expand...
 
Back
Top