Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ssum for each month
- Thread starter jeffp60
- Start date
Create a calculated field MoGroup = Combine(Year(yourdatefield),'-',NumToText(Month(yourdatefield),'00')
You can now use this field to group your records on a report to get a monthly total within each year.
If you want all months across a total panel based on a year, you could set up a series of calculated fields similar to this:
JanTot = Ssum(If(Month(yourdatefield) = 1,youramtfield,0))
FebTot = Ssum(If(Month(yourdatefield) = 2,youramtfield,0))
etc...
Sue Sloan
You can now use this field to group your records on a report to get a monthly total within each year.
If you want all months across a total panel based on a year, you could set up a series of calculated fields similar to this:
JanTot = Ssum(If(Month(yourdatefield) = 1,youramtfield,0))
FebTot = Ssum(If(Month(yourdatefield) = 2,youramtfield,0))
etc...
Sue Sloan
- Status