Solved

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

Posted on 2012-04-13
4
295 Views
Last Modified: 2012-08-13
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
Comment
Question by:davetough
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
HomerTNachoCheese earned 500 total points
ID: 37844714
=format(Ndate,"m")

Added to the report.
Count.accdb
0
 

Author Closing Comment

by:davetough
ID: 37844748
thank you
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37844750
0
 
LVL 6

Expert Comment

by:HomerTNachoCheese
ID: 37844758
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now