G
Guest
My report is based on a crosstab query, when I add a parameter, and try to
open the report, i get the following error Microsoft Jet Databases Engine
does not recogniz " as a valid field name or expression
This is how my parameter looks like
[Forms]![ServiceLevel]![BeginDate]
[Forms]![ServiceLevel]![EndDate]
I also have have the following sql part of the query
Select qryPipelineSum.Date
FROM qryPipelineSum
WHERE (((qryPipelineSum.Date) Between [forms]![ServiceLevel]![beginDate] And
[forms]![ServiceLevel]![EndDate]))
When I enter sql part of the query I that is when I get the following error
Microsoft Jet Databases Engine does not recogniz " as a valid field name or
expression
When I take it out, the report runs but does not filter the dates that I
wanted.
Please help!
open the report, i get the following error Microsoft Jet Databases Engine
does not recogniz " as a valid field name or expression
This is how my parameter looks like
[Forms]![ServiceLevel]![BeginDate]
[Forms]![ServiceLevel]![EndDate]
I also have have the following sql part of the query
Select qryPipelineSum.Date
FROM qryPipelineSum
WHERE (((qryPipelineSum.Date) Between [forms]![ServiceLevel]![beginDate] And
[forms]![ServiceLevel]![EndDate]))
When I enter sql part of the query I that is when I get the following error
Microsoft Jet Databases Engine does not recogniz " as a valid field name or
expression
When I take it out, the report runs but does not filter the dates that I
wanted.
Please help!