Grouping by Past and Future Dates

[Steve C]

In Access 2003, I'm creating a report based on a parameter query that asks
the user for a start date and end date (the data is sales activity tasks that
each have a date when they were/are due). The dates entered are typically
30-40 days older than today's date and 30-40 days out in the future. I want
my report to group by tasks that are due before today's date and ones due in
the future. Any help would be appreciated!

 

[Duane Hookom]

First, IMO parameter prompts are never appropriate user interface. Your users
deserve controls on forms where you can use a calendar control, set defaults,
check for integrity, etc.

That said, you can set a sorting and grouping level to an expression like:
=[DateField]<Date()

 

[Marshall Barton]

In Access 2003, I'm creating a report based on a parameter query that asks
the user for a start date and end date (the data is sales activity tasks that
each have a date when they were/are due). The dates entered are typically
30-40 days older than today's date and 30-40 days out in the future. I want
my report to group by tasks that are due before today's date and ones due in
the future.

Try grouping on an expression like:
=duedate < Date()

 

[Steve C]

Thank you both for the help!
--
Steve C

Try grouping on an expression like:
=duedate < Date()