I have a chart in a report that is run by a query. The query is based off a master query and runs fine, but when I go to open the report and enter the date criteria (the query is set up to run off of a date criteria via a seperate form) an error message comes up that says "Microsoft Jet Database Engine does not recognize 'Forms!daterange!txtstartdate' as a valid field name or expression. And then another message comes up that says "An Error occured while sending data to the OLE Server".
I have other charts in the report that are based off of the date filter and run off of queries based on the master query and they generate correctly. The query that has a problem generating the report has three fields:
1. Result- Count
2. Expr1: Format([inquiredate],"mmm"" '""yy") - Group By
3. Result- Group By
And the inquiredate is the date that is used in the date criteria form and the result field and inquiredate are both pulled from the master query as well.
Any suggestions or solutions? Thanks!!!