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...

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...