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!

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!