Parameters work in queries, but only sometimes in the Report

[cnewlin]

I have rather puzzling question.

I created a crosstab query which selects for a date range.
(I did a basic query, created the report, then went back
to add in the prompts and between statement they are
queried on so that all fields will appear.)

I then used the Report Wizard to group by one field and
then display the results. However, even though there are
plenty of records, certain date ranges give an error
message of "The Microsoft Jet database engine does not
recognize " as a valid field name or expression"

But others give a perfectly good report. Any ideas on why
this would happen or a possible work-around?

Anyone know why this would happen or have a work-around?

 

[Gary Walter]

Hi cnewlin,

Did you explicitly set the
type for your prompt parameters
in your query?

In top menu, click on Query/Parameters
and fill in the dialog box.