Ordering with blanks

[terpster]

I have a report where I have 'due dates' for projects, and I want to order by date asc. Some of the rows do not have a date provided.

I want to have the report show all the itetms with dates first, then the ones with no date at the end.

Anyone have an idea of how to make this happen.

Many thanks

 

[dhookom]

Set the sorting and grouping dialog expression to:
=Nz([Due Date], DateAdd("yyyy",100,Date()))
Any null date fields would be treated as a date 100 years into the future.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[terpster]

Thank you! that worked wonderfully!!