I have an odd problem when using a chart on my report based on a query.
My query pulls from a table, and in the “date” field I have a statement that looks at two unbound text boxes on my report form to gather the dates to narrow the search.
If I have my chart looking at the above mention query it gives me an error message stating that it doesn’t understand my statement.
The query works perfect with a report, just not a graph.
What’s the deal?
Spyyder757
My query pulls from a table, and in the “date” field I have a statement that looks at two unbound text boxes on my report form to gather the dates to narrow the search.
If I have my chart looking at the above mention query it gives me an error message stating that it doesn’t understand my statement.
The query works perfect with a report, just not a graph.
What’s the deal?
Spyyder757
