Exportng to Excel

[toddbingham]

I am exporting some info to Excel. The database looks like this:

Company_ID Department_ID Gross_Amount Check_Date
1a 01 1000 07/02/03
1a 02 900 07/11/03
2a 01 500 07/02/03
2a 02 2000 07/11/03
2b 01 1000 07/02/03
2b 02 500 07/11/03
3c 01 1000 07/02/03
3c 02 700 07/11/03

etc.

What I would like to do when exportig is break it down like this:
Comapany
1a
01 1900
1a
02 2500 ............


So that is is catorgorized by company, then broken down by department and the totals of the checks are added together to form a deprtment total.

Every record in the database has a Company_ID and Department_ID attached.

Thanks in advance.

 

[dcx693]

I don't think your sample report output is making sense.

It looks like it's this:
Company_ID
Department_ID sumofchecks

But that doesn't make sense. In your sample data, the 1900 is from dept's 01 and 02, but it's listed with dept01.

Then you have company_ID 1a again. This time with department 02, but the total goes with company 2a.

 

[toddbingham]

I did list it wrong.

I would like to total each department with each company. There will be several entries in each department.

 

[dcx693]

No problem. Can you relist the output the way it should be?

 

[toddbingham]

I have figured it out. I used a DSUM function in Excel.