How to resolve problems where Msoft Jet Database does not recognis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am trying to run a report based on several queries and I keep getting the
error msg " The Microsoft Jet Database Engine does not recognise XXXX as a
valid field name or expression.
THe XXXX refers to specific criteria based on what changes I have made. One
of the Queries is a cross tab query and this seems to be causing the problem.
The only way I can gather certain information is by completeing this Cross
tab qwuery so I am unsure as to how to work around this.
 
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
 
Back
Top