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.