Chart With Multiple Groups

[shelby55]

Hi

I'm using Access 2003.

I have data that is the month based on discharge date (formatted as mmm-yy) and also a column for fiscal year (Apr to Mar is fiscal year). I want to have a line graph showing each of the months by fiscal year so all of the Aprils together but a different series per fiscal year.

Is this possible and if so what will my query look like? My current query (where I'm still having a problem because the initial data point isn't showing) is:

SELECT DateSerial(Year([DisDate]),Month([DisDate]),1) AS MonthEnd, Avg(FLO_Data.TotalDays) AS ALOS
FROM FLO_Data
WHERE (((FLO_Data.InstName)=[forms]![frmGraphDialog]![lstInst2]) AND ((FLO_Data.Disp) Like "1*") AND ((FLO_Data.DisDate) Between [forms]![frmGraphDialog]![txtStartDateA] And [forms]![frmGraphDialog]![txtEndDateB]))
GROUP BY DateSerial(Year([DisDate]),Month([DisDate]),1)
ORDER BY DateSerial(Year([DisDate]),Month([DisDate]),1);

Thanks.

 

[dhookom]

I don't see anything that suggests a field is formatted as mm-yy.

I'm not sure what the data or graph need to look like but it might require a crosstab query that has fiscal year as the column heading. If you use a crosstab, you must declare the data type of the parameters.

Duane
Hook'D on Access
MS Access MVP