formating charts/graphs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rose M - 30 Jan 2007 17:14 GMT

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?

Reply to this Message

Duane Hookom - 31 Jan 2007 02:13 GMT

Provide your Row Source property.

Signature

Duane Hookom
Microsoft Access MVP

> 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?

Reply to this Message

Rose M - 31 Jan 2007 11:28 GMT

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

In Design View -

> Provide your Row Source property.
>
[quoted text clipped - 3 lines]
> > 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?

Reply to this Message

Duane Hookom - 31 Jan 2007 14:21 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> SELECT [MONTH],[DAYS],[EVENINGS],[NIGHTS] FROM [7 TOTAL REPORT BY SHIFT];
>
[quoted text clipped - 7 lines]
> > > 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?

Reply to this Message