Month Display

[xxlu]

I extract the monthly report to count the number of new customers by using query. In my query, I group the data by using the field Date

DatePart("m",[RegistrationDate]), the result comes with 1,2,3....12 to display Jan, Feb, Mar....Dec. How can I make these numbers into the format of Jan, Feb...Dec?

Another question is if there is no new customer for that month, the field is blank. I want it to display "0" if the counting result is nothing.

Many many thanks for your help.

 

[Rich]

"mmm" or "mmmm"

 

[xxlu]

Thanks for your help very much. But I have tried "mmm", it shows "Invalid procedure call". So have to find other solution. Anybody can help??

Thanks a lot.

 

[Pat Hartman]

Add another column to the query to include the formatted month.
Format(RegistrationDate,"mmm")

I hope you are also including the year as well as the month in your group by. If not, you'll start miscounting when you get data for multiple years in the table.