Create a Graph (report) based on a query with form filters.

bobbye_69

Registered User.
Local time
Today, 17:59
Joined
Apr 22, 2014
Messages
26
I am trying to generate a report that is based off of a query. The query has a form filter that it needs to filter the data. I keep getting a jet engine error and couple others.
The form has year, start week, and end week on it. I can get the query to work fine. When I try to open the report, Access says it doesn't recognize the " [Forms]![frmUptimeFilter]![StartWeek] " as a valid field name or expression.
Can anyone give me direction on this?
 
Is form "frmUptimeFilter" open when your report opens?
Show the SQL-string the report's recordsource is based on.
 
Yes, it was open. I have went a different route and got what I needed. Thanks
 

Users who are viewing this thread

Back
Top Bottom