Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
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

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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