Parameter Query Problem

  • Thread starter Thread starter mark gateson
  • Start date Start date
M

mark gateson

I have a large Database with many data tables that link together.

If i have a Query via ODBC that accesses just one of these data tables then
i can run a parameter query and get the results i want, but if i have
multiple tables in the query then the parameter query does not work and i get
a blank/empty return?

Is there a way that i can solve this?
 
Duane,

thank you for the response, as far as troubleshooting goes the cross table
query runs fine without the parameter but i am then looking to run smaller
queries by setting date/field parameters for users so they can bring in
smaller amounts of data and it is at this stage that it stops running.

I will l.ook throu TEK tips and see if there any thing on there

regards
 
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
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top