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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

On Click expression error 2
MS Access 2007 ends unexpectetly - Calls VB6 DLL 6
NOT RELEASE SP3 of MSOFFICE!!! 2
Access 2007 query (large IN statement), alternate approaches 8
Runtime 2007 and autodialer 1
Access won't open from batch file when scheduled 3
End of MSAccess? Fim do MSAccess? 11
Database Corrupt? 3

Back
Top