Change axis value

[gthing66]

hey guys,

I have created graphs based on a database.. the figures entered into
the database are dates shown as 07/08/07 for example.

I have managed to create these graphs using queries but the y axis
shows up as '8'. how do i change this to show Aug instead?

Cheers,
Grant.

 

[scubadiver]

Change the formatting in the query.

format([field], "mmm")

or some such...

 

[gthing66]

thanks It worked.

one more thing Month 01 shows up as Dec! when it should be Jan?

 

[scubadiver]

Should do but not sure why it isn't happening