Query to Report question

[Hawkide]

I have a query that returns a count grouped by month. When I create a chart on a report, the order of the months are not Jan thru Dec. I would like my chart to display the months in sequetial order along the x-axis.

 

[lespaul]

add:

ORDER BY Format ( tblX.FinishDate, "MM" )

to the end of your query.


Leslie

 

[Hawkide]

I already have that, but the query was returning the data sorted like :

August
December
July
October

(There are only 4 months with data)

I added and sorted on the following field:

intMonth: Month([tblX].[FinishDate]

As expected, the query returns data sorted as:

July
August
October
December

but the chart on the report still displays the x-axis as:

August
December
July
October

Charts do not seem too intuitive in Access 97. Any ideas???

 

[jinglin]

Try this: in design view of the report, click Sorting and Grouping icon from tool bar, from there you can sort the field [FinishDate] either by asc or desc.

 

[PHV]

And usually avoid ORDER BY clause in the underlaying query of a Report with Sort/Group stuff.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Hawkide]

Thanks guys...