Criteria in a Crosstab query

  • Thread starter Thread starter Samina Gordon
  • Start date Start date
S

Samina Gordon

Hello,

I have created a crosstab query to create data for a
report in a week schedule format. However, when I try to
enter criteria to only display records within a certain
date range, e.g. Between [Enter Start Date: ] And [Enter
End Date: ] access won't accept it.

This criteria works in my other standard query.

Can anyone help?

Thanks
Samina
 
You also need to enter it into the parameters dialog box
With the query open in design view, right click on the grey back ground and
select Parameters ..
 
Hello,

I have created a crosstab query to create data for a
report in a week schedule format. However, when I try to
enter criteria to only display records within a certain
date range, e.g. Between [Enter Start Date: ] And [Enter
End Date: ] access won't accept it.

This criteria works in my other standard query.
Click to expand...

This is an annoying little glitch with Crosstab queries. It is always
ALLOWED to explicitly define a query's parameters; with a crosstab
it's REQUIRED.

Open the query in design view, and right mouseclick in the background
of the tables (or use the View menu option) and select Parameters.
Copy and paste the [Enter Start Date: ] and [Enter End Date: ]
parameters - they must match EXACTLY - and specify that they are of
Date type.
 
You must explicitly declare the parameter data types. Select
Query|Parameters and enter
[Enter Start Date: ] Date/Time
[Enter End Date: ] Date/Time
 
I usually create a 2nd query, where I add the Crosstab and the original
query (Query1) with dates.

Add
Between [Begin Date] and [End Date] as the criteria for Query1.MyDate

Hope this helps.

Cameo
 
Back
Top