Prev: Recieving Inventory Query
Next: Function is not availalbe in expressions in query expression error
From: Leath on 4 May 2010 11:34
I have a crosstab query in which I am prompting for a date range (Between
[Enter Start Date] and [Enter End Date]). When I run this report it prompts
me multiple times for the date range.

For example: I have a report pulling from one crosstab query which contains
10 graphs. The report prompts me 10 times for a start and stop date.

How do I design the crosstab query to only prompt once for the entire
report?
(it does the same thing if I prompt for other parameters also and isn't
limited to graphical reports - it will do multiple prompts for list-type
reports also)

Thanks in advance!
From: KARL DEWEY on 4 May 2010 11:43
Use an unbound form to enter the data for the query criteria.
Refer to the text boxes on the form like this --
[Forms]![YourFormName]![TextBoxname]

Declare these as DateTime datatype in the crosstab query.

--
Build a little, test a little.


"Leath" wrote:

> I have a crosstab query in which I am prompting for a date range (Between
> [Enter Start Date] and [Enter End Date]). When I run this report it prompts
> me multiple times for the date range.
>
> For example: I have a report pulling from one crosstab query which contains
> 10 graphs. The report prompts me 10 times for a start and stop date.
>
> How do I design the crosstab query to only prompt once for the entire
> report?
> (it does the same thing if I prompt for other parameters also and isn't
> limited to graphical reports - it will do multiple prompts for list-type
> reports also)
>
> Thanks in advance!
 | 
Pages: 1
Prev: Recieving Inventory Query
Next: Function is not availalbe in expressions in query expression error