Please help needed on linear chart

[Guest]

I finally have the query going on, thanks to this wonderful site and MVP and
everyone that replies.
My query looks like
SELECT WEEKTEST.week, DSum("Signed","[WEEKTEST]","Week<=" & [Week]) AS
Signedcons, DSum("Rand","[WEEKTEST]","Week<=" & [Week]) AS Randomized,
DSum("WC","[WEEKTEST]","Week<=" & [Week]) AS WithdrewConsent,
DSum("OND","[WEEKTEST]","Week<=" & [Week]) AS SubjOnDrug,
DSum("SF","[WEEKTEST]","Week<=" & [Week]) AS ScreenFail
FROM WEEKTEST;

Works very well, where I need to show in a linear chart the accumlative
field per week.
The only problem is the data on the chart is counting I dont need to
summarize or average, only display, and is not allowing me to choose the
none. Can someone help me???Tia

 

[Duane Hookom]

You can set the row source of your chart control to your query.