MS Access 2007

  • Thread starter Thread starter hfd
  • Start date Start date
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!
 
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
 
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? :-)
 
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
 
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...
 
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...
 
Back
Top