Chart, forces count for data. takes to long

[mike02]

Hey,



I have my query set up like this:

CompanyID....MonthlyDate....Expr1: (formula).

Query runs fine, quick, and filters as I want it to in datasheet view on my form. However, I want to make it visually appealing and easier to read by creating a chart.
When I create the chart I try and set it up with the wizard to filter on CompanyID, and X-axis is Monthly-Date, and the Expr1 is the Data. (Line Chart).

It is forcing me to Use CountExpr1. this takes too long, and causes a long delay when running. As well it returns 1, as there is one value per month. How can i change it to set it up to be value, not count? The error says its the formating of the query, but I cant adjust the formatting in the query. Now, im really confused on where to go.


Thanks,

[mike02]

I got it to work, I went into the Query defining the chart under properties, and was able to adjust everything. Thanks, anyways!

[RuralGuy]

Thanks for posting back with your success and solution.