Problem With Parameters in Cross Tab Query

B

Brian

I can't figure out what I have done wrong in trying to get a cross tab query
to recognise parameter dates.
In design view the parameter is -
(Field is TransDate)
Between [Forms]![Main Menu]![txtstartdate] And [forms]![Main
Menu]![txtenddate]

In query view the statement is -
PARAMETERS [forms]![Main menu]![txtstartdate] DateTime, [forms]![main
menu]![txtenddate] DateTime;
TRANSFORM Sum([PLINV&EXPPart2].Amt) AS SumOfAmt
SELECT [PLINV&EXPPart2].TransDate
FROM [PLINV&EXPPart2]
WHERE ((([PLINV&EXPPart2].TransDate) Between [Forms]![Main
Menu]![txtstartdate] And [forms]![Main Menu]![txtenddate]))
GROUP BY [PLINV&EXPPart2].TransDate
PIVOT [PLINV&EXPPart2].DebExp;

When I try to run the query from a user input form I get the error message
"Microsoft Jet database does not recognise " as a valid field name or
expression".

I relied a lot on good community help in getting this far so my SQL
knowledge at its limit at this point.

Can anyone help?
 

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

Parameters Expression In A CrossTab Query 4
Can't Ge A Report To Accept Paraemters 3
How to display zero value in blank fields of Cross Tab query 0
Running Update Query in VBA fails 5
Parameter in query not taking the value 3
Want a Parameter for date range driving a cross tab query 2
Expression is typed incorrectly or . . . . change to variables 1
OpenReport Action was Cancelled when attempting to Preview a repor 1

Top