I am trying to create a graph based on a query that gets its parameters from a form [Bid - bucket comparison]. I get an error (shown on the attached file) that says Jet does not recognize my term forms![Bid - Bucket Comparison]!cmbEstimator1. How can I overcome this problem?

I believe that you need to change from:
Forms![Bid - Bucket Comparison]!cmbEstimator1

to

forms![Bid - Bucket Comparison].cmbEstimator1


The reason is that the ! marks cmbEstimator1 as a field, but using the period (.) will tell it that it is a control.

That did not seem to do it. Here is my code in my query:

WHERE ((([Project File].Estimator)=[forms]![Bid - Bucket Comparison].[cmbEstimator1] Or ([Project File].Estimator)=[forms]![Bid - Bucket Comparison].[cmbEstimator2] Or ([Project File].Estimator)=[forms]![Bid - Bucket Comparison].[cmbEstimator3]) AND (([Project File].[Current Bid Date])>=[forms]![Bid - Bucket Comparison].[txtBeginningDate] And ([Project File].[Current Bid Date])<=[forms]![Bid - Bucket Comparison].[txtEndingDate]))

I still get the same error. Could it be generated somewhere other than the criteria fields in my query?

Sorry, I messed you up. I was thinking you were doing this in code. You do need the ! for the controlsource type of formula.

Explain what you are trying to do as and where you are using this. Is it a criteria in a query?

If so, I believe it won't work as is anyway.

The query is part of an estimating package. When an estimator bids a project, they enter prices for a project (1 or more separate prices). These prices are combined to generate a total bid for a project. The project's contract is then either awarded or lost.

My query summarizes and compares the bids and their results for estimators selected by the user. The user selects the date range for the report, and the estimators to compare. The report shows monthly totals, estimator totals, and report totals.

The query works great for this report. The estimating manager has asked that I display this same information graphically.

I created a pivot table and pivot chart with this query but I have no idea how to incorporate this into a report.

What I am trying to do is simple create a graph (using Access's graph wizard) to display the bid totals (y-axis) on a date by month chart (x-axis) for the estimators selected (data in graph).

Does this help?

I'm not real great at SQL Syntax, but I think you may have a problem because you are using special characters ( - ) and spaces within the names of your form.

Another possible problem is that one or more of the controls that you are referencing are named the same as a field in your table (if you are using a bound form).