Capturing parameter input
  Home FAQ Contact Sign in
microsoft.public.access.queries only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... access.queries Profile…
 Up
Capturing parameter input         


Author: Hugh
Date: Sep 8, 2007 08:20

I have a report based upon a parameter query that requires the input of a
beginning date and an ending date to filter the required records. I want to
capture the input and use it to show the date spread for the recordset in
the report header, is this possible? and if not is there another solution?

Hugh
2 Comments
Re: Capturing parameter input         


Author: Rick Brandt
Date: Sep 8, 2007 08:49

Hugh wrote:
> I have a report based upon a parameter query that requires the input
> of a beginning date and an ending date to filter the required
> records. I want to capture the input and use it to show the date
> spread for the recordset in the report header, is this possible? and
> if not is there another solution?
> Hugh

Just use the parameter markers in your report as if they were fields in the
query. The report will pick them up.

EX: ="From " & [Enter Start Date] & " to " & [Enter End Date]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
no comments
Re: Capturing parameter input         


Author: Allen Browne
Date: Sep 8, 2007 08:54

If you have parameters named (say) StartDate and EndDate in your query, you
can add a text box to your report and set its Control Source to:
=[StartDate]

Further suggestions:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Hugh" hotmail.com> wrote in message
news:u3UQkui8HHA.5360@TK2MSFTNGP03.phx.gbl...
>I have a report based upon a parameter query that requires the input of a
>beginning date and an ending date to filter the required records. I want to
>capture the input and use it to show the date spread for the recordset in
>the report header, is this possible? and if not is there another solution?
>
> Hugh
no comments