Crosstab Query error message

  • Thread starter Thread starter Larry Miller
  • Start date Start date
L

Larry Miller

Need help please with the following:
I have a crosstab query with a criteria for a field expression that I can't
get to work. It worked in Access 95 but not in Access 2002.

The field expression is
Exprl: "Qtr" & DatePart ("q", [ECD] and the criteria (which runs the
support query is

Between [Forms]! [Scorecard Reports]! [Beginning Date] And [Forms]!
[Scorecard Reports]! [EndingDate]

I get an error saying "The Microsoft Jet Database engine does not recognize
'Forms! [Scorecard Reports]! Beginning Date as a valid filed name or
expression.

Even if I take the criteria out of the support query, the crosstab query
still give me the same message.

Suggestions? Thanks for any help you might have.
 
Did you explicitly declare the parameters [Forms]![Scorecard Reports]!
[Beginning Date]
And [Forms]![Scorecard Reports]![EndingDate]? (Choose Parameters from the
Query menu.) Most crosstab queries require that you do this - and it's a
good idea for any parameter query.


--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 

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

crosstab query with parameter query 5
Crosstab query error 1
crosstab query parameters for dates 1
Parameter Queries in Crosstab Query 2
Crosstab Query with Criteria 2
Parameter Value in Crosstab Query 4
Crosstab 3
USING PARAMETERS IN A CROSSTAB QUERY 4

Back
Top