Access Crosstab Query Should Link To Forms

[Guest]

MS-Access Crosstab query doesn't take the form field in the criteria. So one
need to create a crosstab query and then build another select query on top of
that which will have the filtering criteria for the form.

Can we make a single query??

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...121db075fe&dg=microsoft.public.access.queries

 

[Duane Hookom]

This question gets asked and answered several times per week. You can use
parameters/criteria in crosstab queries if you explicitly identify the data
types of the criteria. Select Query->Parameters and enter

Forms!frmA!txtB Date/Time

 

[Anonymous]

I wonder why Crosstab queries behave that way...I was stuck with a
crosstab a few weeks ago until I figured that out on my own...

Jeff

 

[Duane Hookom]

A clue to why they behave that way is if you enter the Column Headings
property, you won't need to declare your data parameter types. For instance
if you have a date criteria but set your column headings property like:
Column Headings: "Jan","Feb","Mar","Apr"
You don't need to specify the data types of your parameters.