davetough
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
test this
DB-Q-27675150.accdb
DB-Q-27675150.accdb
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.
ASKER