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)
 
Back
Top