Connecting Tech Pros Worldwide Forums | Help | Site Map

Help! Calculations in a report

Newbie
 
Join Date: Apr 2007
Posts: 3
#1: Apr 19 '07
Hi there,
I have a report that details 12 months rolling data. It caluculates the total, but I want it to calculate the total for only the current year. So far it has me stumped!!!

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: Apr 19 '07

re: Help! Calculations in a report


Quote:

Originally Posted by Sarahc

Hi there,
I have a report that details 12 months rolling data. It caluculates the total, but I want it to calculate the total for only the current year. So far it has me stumped!!!

Create a group header for the year and put the calculation in the group footer.
Newbie
 
Join Date: Apr 2007
Posts: 3
#3: Apr 19 '07

re: Help! Calculations in a report


Quote:

Originally Posted by mmccarthy

Create a group header for the year and put the calculation in the group footer.

Thanks for that - worked a treat
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#4: Apr 19 '07

re: Help! Calculations in a report


Quote:

Originally Posted by Sarahc

Thanks for that - worked a treat

You're welcome.
Reply


Similar Microsoft Access / VBA bytes