new issue...graphs

[thewabit]

How would I write a function or a module to tell a month that is displayed in the table as a number to display on the graph as abbreviations such as Oct, Nov, Jan, etc?

[Guus2005]

The format command will return the month if you enter a date.
To provide the date if you only have a number, convert the number to a date using the dateserial command. Year(1) and Day(1) numbers are necessary but obsolete.

format(dateserial(1, intmonth, 1),"mmm")

HTH

[thewabit]

Thanks Guus,

Would that be a public function?

[Guus2005]

Format and Dateserial are Access build-in functions.
You can use them in a user defined function or in a query:

select format(dateserial(1, [MonthField], 1),"mmm") as MonthTxt From table1

Where monthfield is the field where the month is stored.

Enjoy!