Sort Query, on Several Date Fields, Nulls at End

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!
 
Back
Top