Charts

[dpw]

I'm attempting to plot monthly statistics on a bar chart (in a form) for data over the past 3 years.

I would like to compare the data for each month. i.e. Jan 2000, Jan 2001, Jan 2002 'bars' next to each other and NOT Jan '00, Feb '00 etc through to Nov '02, Dec '02 as I keep getting.

Thanks

D

 

[rich.barry]

Try basing your chart on a query that has a calculated date field that gives you the correct sort order.

e.g.

SELECT Format([Table1]![DateField],"mm/yyyy") AS DateSortOrder, Table1.DateField
FROM Table1
ORDER BY Format([Table1]![DateField],"mm/yyyy");