Grouping by Past and Future Dates

  • Thread starter Thread starter Steve C
  • Start date Start date
S

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!
 
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()
 
Steve said:
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.
Click to expand...

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