In Access how do i change fields in a chart ?

[Steve I]

I've created a chart in Access using the chart wizard. I'm importing data
from a query. One of the fields I'm using is a date field and I want to use
day of month in the chart, but when I drag the field onto the chart it
changes from "open Date" to "Open Date by month". As the query only contains
1 months data, there is only 1 bar in the chart, which makes it fairly
useless. How do I extract day of month so that I have one bar for each day of
the month ?

Any help will be appreciated.

 

[Duane Hookom]

Find the chart's Row Source query and modify it to remove the Group
By/Totals.

 

[Steve I]

Thanks, I did what you said and it worked.