Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

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
0
davetough
Asked:
davetough
  • 2
1 Solution
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now