How to resolve problems where Msoft Jet Database does not recognis

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.
 
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
 

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

Microsoft Jet Database engine does not recognise... 0
Microsoft Jet database engine does not recognize... 2
Issue with transform query 2
Microsoft Jet Engine Does Not Recognise...... 1
Jet database engine 7
Want a Parameter for date range driving a cross tab query 2
Error on a cross-tab query 1
The Microsoft Jet database engine does not recognize 0

Top