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