Please help needed on linear chart

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

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

--
Duane Hookom
MS Access MVP


"Savanah" wrote in message
...
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