HOW TO: Code Params for Report

[Wayfarer]

I am using Microsoft Access 2000.

I am designing a report using an aggregate query parameterized on a
date range. I am using a form for users to select the range, allowing
"First Quarter 2005" to produce global variables for both gsStart
(e.g.-"07/2004") and gsEnd (e.g.-"09/2004").

I want to feed the dates to the report query programmatically. If I
build the query with a WHERE option for the date field and add a
BETWEEN clause, I can't find a way to NOT have the dialogs for
inputting each param.

How do I do this? I've tried Googling on it, but haven't found the
magic search string that'll bring up the info I need.
Can anyone help me, or am I beyond all help?

TIA...

Neill

[Brian]

"Wayfarer" <ne**********@gmail.com> wrote in message
news:10*********************@z14g2000cwz.googlegro ups.com...

I am using Microsoft Access 2000.

I am designing a report using an aggregate query parameterized on a
date range. I am using a form for users to select the range, allowing
"First Quarter 2005" to produce global variables for both gsStart
(e.g.-"07/2004") and gsEnd (e.g.-"09/2004").

I want to feed the dates to the report query programmatically. If I
build the query with a WHERE option for the date field and add a
BETWEEN clause, I can't find a way to NOT have the dialogs for
inputting each param.

How do I do this? I've tried Googling on it, but haven't found the
magic search string that'll bring up the info I need.
Can anyone help me, or am I beyond all help?

TIA...

Neill

If you've created a form (say, frmRange) for the user to enter the range,
then the simplest thing would be, instead of using global variables, to put
your start and end values into a pair of hidden textboxes on the form (say,
txtStart and txtEnd). Then, in the query, replace the parameters with
references to the form e.g.

BETWEEN [Forms]![frmRange]![txtStart] AND [Forms]![frmRange]![txtEnd]

[Tony Toews]

"Wayfarer" <ne**********@gmail.com> wrote:

I am designing a report using an aggregate query parameterized on a
date range. I am using a form for users to select the range, allowing
"First Quarter 2005" to produce global variables for both gsStart
(e.g.-"07/2004") and gsEnd (e.g.-"09/2004").

I want to feed the dates to the report query programmatically. If I
build the query with a WHERE option for the date field and add a
BETWEEN clause, I can't find a way to NOT have the dialogs for
inputting each param.

How do I do this? I've tried Googling on it, but haven't found the
magic search string that'll bring up the info I need.
Can anyone help me, or am I beyond all help?

Create the Where clause of the docmd.openreport line using VBA code.
Microsoft Access Report Printing Criteria Selection Form
http://www.granite.ab.ca/accsrprt.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm