formating charts/graphs

[Rose M]

I have a graph in ACCESS from a query - I have a field month - set as Text
(Oct 06, Nov 06, etc). In my graph it changes to Oct 07...I have formatted
the field as text in the source box even and I can get the design view to
show correctly, but when I view the chart it still says Oct 07, Nov 07....
How do I get it to show the correct text value on the graph?

 

[Duane Hookom]

Provide your Row Source property.

 

[Rose M]

SELECT [MONTH],[DAYS],[EVENINGS],[NIGHTS] FROM [7 TOTAL REPORT BY SHIFT];


In Design View -

 

[Duane Hookom]

Sorry, that didn't help much. We don't know the data or calculation behind
[MONTH].

Try to reply with everything you think we might need.

--
Duane Hookom
Microsoft Access MVP

SELECT [MONTH],[DAYS],[EVENINGS],[NIGHTS] FROM [7 TOTAL REPORT BY SHIFT];


In Design View -

Provide your Row Source property.