H
Howard
I have a simple SELECT query that extracts all fields from a table that are
within two dates displayed in text boxes on a form. ([forms]![Management
Reports Memu]![txtFromDate] and [forms]![Management Reports
Memu]![txtToDate]
Its called ExitsFilteredByDate
I do all sorts of other queries and reports using this query as a source and
they work fine but when I try to do a cross tab query using it as the source
I get an error saying tthat the jet engine does not recognise
[forms]![Management Reports Memu]![txtFromDate] as a valid field name or
expression.
The same cross tab applied to the raw base table works OK
Any ideas what is going on and how to fix it?
Howard
within two dates displayed in text boxes on a form. ([forms]![Management
Reports Memu]![txtFromDate] and [forms]![Management Reports
Memu]![txtToDate]
Its called ExitsFilteredByDate
I do all sorts of other queries and reports using this query as a source and
they work fine but when I try to do a cross tab query using it as the source
I get an error saying tthat the jet engine does not recognise
[forms]![Management Reports Memu]![txtFromDate] as a valid field name or
expression.
The same cross tab applied to the raw base table works OK
Any ideas what is going on and how to fix it?
Howard