MS Access 2007

H

hfd

Can you filter a crosstab in MSAccess using a Combo Box? Seems to
error out everytime we try it. Thanks for your quick answer!
 
J

John Spencer

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
H

hfd

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County




- Show quoted text -
Click to expand...

John, Thanks, i found where you helped someone else with this same
problem. Thanks so much. What do I owe you? :)
 
J

John Spencer

Owe? Thanks and if **YOU** wish make a contribution to your local Heart charity.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
G

Graciela Herrera

John Spencer said:
Owe? Thanks and if **YOU** wish make a contribution to your local Heart
charity.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
G

Graciela Herrera

John Spencer said:
Owe? Thanks and if **YOU** wish make a contribution to your local Heart
charity.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Top