Sort Query, on Several Date Fields, Nulls at End

G

Guest

I have a query that pulls records with various status dates. Some have dates
in a Completed field, some have dates in a Referred field, some have dates in
a Closed field and some have not been processed so they have no dates (Nulls)
in any of the fields. I need to sort the query by Completed in ascending
order, then Referred in ascending order, then Closed in ascending order and
the Nulls at the bottom. Help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort on Multiple Fields, Nulls at End 15
Sort with Nulls at End 2
How sort by latest of two date columns ? 2
Criteria to return all records if selection from form is null 3
Union query returns date as Text which doesn't sort correctly 1
managnig nulls in combobox sort 1
complex query to pull unique values 6
sort query with null values at end 2

Top