Please help needed on linear chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top