(Msg. 1) Posted: Thu Oct 29, 2009 8:41 am
Post subject: Grouping by Past and Future Dates Archived from groups: microsoft>public>access>reports (more info?)
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!
--
Steve C
(Msg. 2) Posted: Thu Oct 29, 2009 9:34 am
Post subject: RE: Grouping by Past and Future Dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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()
--
Duane Hookom
Microsoft Access MVP
"Steve C" wrote:
> 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!
> --
> Steve C
(Msg. 3) Posted: Thu Oct 29, 2009 11:08 am
Post subject: Re: Grouping by Past and Future Dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Steve C wrote:
>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()
(Msg. 4) Posted: Thu Oct 29, 2009 8:14 pm
Post subject: Re: Grouping by Past and Future Dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you both for the help!
--
Steve C
"Marshall Barton" wrote:
> Steve C wrote:
>
> >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()
>
> --
> Marsh
> MVP [MS Access]
> .
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other