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 fine, but the chart won't let me put the AvgTimeWkly and Baseline fields on the data side of the chart without grouping it by "count". WHICH DOES ME NO GOOD! The error says that my fields are either text, date, or key fields so they can only be counted.
I know these fields are numbers. They start that way in the tables and I can't think of why they would have changed. Any ideas?
The query runs fine, but the chart won't let me put the AvgTimeWkly and Baseline fields on the data side of the chart without grouping it by "count". WHICH DOES ME NO GOOD! The error says that my fields are either text, date, or key fields so they can only be counted.
I know these fields are numbers. They start that way in the tables and I can't think of why they would have changed. Any ideas?
