Counting Data

[kwooten]

I am currently running a pivot table report in excel but I have quite a few processes I have to run to create the data for the report. I feel Access will be able to run these processes for me much faster. I have to reassign the time to a "code" for instance any day between 0-30= 1. My excel table looks something like this:

LOB 0-30 days 31-60 days
Retail 5 4


Commercial 6 2

In Access I have created a column for each range which is: "0-30: IIF(codefordays='1', count(codefordays))"..

This assigns a 1 next to each days <=30.

I need to create a report that looks similar to the excel table.. Is there a way to sum each range based on LOB?

I put this is the query section because I thought I would have to do something within the query to make the report run correctly.

[June7]

Summing based on the LOB value is an aggregate totals query with a Group By clause. Build a report using Grouping & Sorting features with aggregate calcs in group header/footer section.

[kwooten]

That was what I thought I needed to do.. Ill just need to make the details invisible correct?

[kwooten]

I got my table looking right... How can i get a default value of zero for any blank rows?

[June7]

Yes, if you don't want to show details, set the Detail section visible property to no.

By table do you mean query? Blanks rows where - in report?

[kwooten]

I figured it out.. I had to make the query data insert a '0' for any value not equal to the code assigned for each range.