up vote 0 down vote favorite
share [g+] share [fb]

I'm looking for a way to split a large block of data in access into quarters and then total all of the data by quarter.

I know how to generate a report and have it break everything off into quarters I just am not sure how to make sure it totals each column at the end of the quarter. Right now, i'm just exporting it into excel and doing SUM formulas by hand. I'm fairly new to Access, so i'm not sure if this is possible or i'm just overlooking a simple step.

link|improve this question
80% accept rate
1  
You will need to give us some idea of your data structure for this... – JNK Sep 27 '10 at 14:09
Format(DateField, "yyyy-q") should get you started, I'd think. – David W. Fenton Sep 27 '10 at 17:48
feedback

1 Answer

up vote 0 down vote accepted

Figured I would give an explanation of how I did this.

Out the data into Access and did a Report Wizard. I just sorted by Date, and from there did a summary by quarter. On the Summary options, I just did a SUM function for all data inside of the quarter, and from there I had a nice little report that was separated by quarter and had all the totals for each column.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.