If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart using query with between
Hello,
I create a report with 3 charts in it. All works fine! Now I need to give the user the ability to control the start and end date to collect data for the chart. So I simply added a between criteria on the relevant field. I checked the query and it returns the proper result, but when I try to open the report I get an error The microsoft jet database engine does not recognize the 'Forms!...' as a valid field name or expression. They query does, why is the report then spitting out this error? Help? Thank you, QB |
#2
|
|||
|
|||
chart using query with between
Found the answer, I need to use parameters in the query. Thank you Duane
Hookom! See: http://www.pcreview.co.uk/forums/thread-1990421.php "QB" wrote: Hello, I create a report with 3 charts in it. All works fine! Now I need to give the user the ability to control the start and end date to collect data for the chart. So I simply added a between criteria on the relevant field. I checked the query and it returns the proper result, but when I try to open the report I get an error The microsoft jet database engine does not recognize the 'Forms!...' as a valid field name or expression. They query does, why is the report then spitting out this error? Help? Thank you, QB |
Thread Tools | |
Display Modes | |
|
|