numbers in chart

[Guest]

I ran a query to calculate the cumalative totals by day. Here is the statement:

SELECT DailyQuantities.ItemID, DailyQuantities.EndDate,
DailyQuantities.QuantityCompletedDuringTimePeriod,
DSum("QuantityCompletedDuringTimePeriod","DailyQuantities","ItemID='" &
[ItemID] & "' AND EndDate<=#" & [EndDate] & "#") AS RunSum
FROM DailyQuantities;

The RunSum column is where the cumalative totals go. The query works fine,
but when I try to take the values in the RunSum column and put them in a
chart, they come up not being numbers but general text. I tried to change the
format of the column to numbers but it still won't work. When I tried to
export the data to Excel there was an apostrophe in front of all the numbers.
I don't know if this has something to do with it or not.
Any help would be appreciated.

Thank You.

 

[[MVP] S.Clark]

Why the need for the DSum()?

If nothing else, you can wrap a cdbl() around the entire expression. You
may need to trap to for Nulls using Nz().