Grouping by Dates before & after Today's date

[Steve C]

I am creating an Access 2003 report based on a parameter query that asks for
a start date and an end date. The dates entered are typically for activities
completed in the last 30 days and ones due in the next 30 days. I want the
report to group on activities older than today's date and after today's date.
I'm thinking I have to build a custom expression in the Sorting and Grouping
dialag box, but I'm not sure how to create it. Thanks for any help you can
give me.

 

[Marshall Barton]

I am creating an Access 2003 report based on a parameter query that asks for
a start date and an end date. The dates entered are typically for activities
completed in the last 30 days and ones due in the next 30 days. I want the
report to group on activities older than today's date and after today's date.
I'm thinking I have to build a custom expression in the Sorting and Grouping
dialag box, but I'm not sure how to create it.

Try using an expression like:

=yourdatefield < Date()

That will have a value of True (-1) for older dates or False
(0) so sorting Ascending will put the older dates before the
upcoming dates.