Search results

I am trying to create a line chart from a query that has three fields; Date, AvgTimeWkly, and Baseline. We want to compare the AvgTimeWkly numbers to the Baseline numbers. I had to jump through a few hoops to get the baseline. (See "Creating a 'Baseline' on chart..." thread). The query runs...

It works! Thanks for the help- I did what you suggested with the make table query and it worked. I also created a macro to run the query, then print the chart. The baseline will always reflect the most current data.

So close I can smell it... Wonderful Suggestions!!! Thanks guys- I have created a summary query that calculates the single average of all of the averages from the original query. And it works- there is a single value in one field with the correct average, and it should be a dynamic value...

I have a query with 2 fields, Date and AvgTimeWkly. The query only pulls records with a date within the last 3 months. I need the query to calculate the average of all AvgTimeWkly records that it pulls and put that same value in a new field called Baseline for all records. This way a line...

Possible Solution You may have a reason for the many-to-many that I don't realize, but I would like to suggest a one-to-many. With barcode being the primary key in the barcode table there shouldn't be any duplicates. A one-to-many gives you a few options. After the tables fill with data you...

Relationship Have you formed a relationship between the Primary Key "Barcode Number" in the Barcode table and the Foreign Key "Barcode Number" in the Product table?