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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help w/a running total using a monthly group

Status
Not open for further replies.
Feb 28, 2002
26
US
I have data that contains the name of the month in a column. I need to create a report that contains just the totals for each quarter. So I need to sum the amounts for Jan, Feb, Mar for Q1; Apr, May, Jun for Q2; etc...

Is there a way to just count the data w/out grouping it and displaying the count on the report?

Regards.
 
Do you want to Sum the data or Count the data? Which is it? Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
 
I need to count the data that meets a certain criteria. Regards...Guy
 
Is the criteria in question already addressed by record selection formulas, or is it a different set of criteria? Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
 
It is different.

I have a set of data that I need to group by quarter but need to use months as I do not have quarter in my data.

Let me know if I can provide any other information.

TIA...Guy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top