display month totals in report and have 1 display for january, 2 for feb, etc..

hello I am attaching sample database-
open database and open rpt1
the report displays totals for each month-
I have an empty field in report called [month]-
is there a way to have 1 display in that field for january- 2 for february, etc..
thank you
Count.accdb
davetoughAsked:
Who is Participating?
 
HomerTNachoCheeseCommented:
=format(Ndate,"m")

Added to the report.
Count.accdb
0
 
davetoughAuthor Commented:
thank you
0
 
Rey Obrero (Capricorn1)Commented:
0
 
HomerTNachoCheeseCommented:
You could also create a query based on your table that has this formula, then base the report on the query.  Having this formula in your report/group footers might not turn out so well if you increase the complexity of the report.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.