Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .