Calculating from a query based subform

[keiath]

Hi Again



On my master form I have a subform called invoices this is tied by Site Number to the record on the form which is has the following important information, site code. group code, exp code an amount.

On another subform via a query I have a summary of all the invoices by exp code and group code.

On another subform I need to create a Income an Exp.

I have two combo boxes 1 for the Group Code, and another for the expense code what I want it to now do is look up group code – exp code = Total amount. There is currently only 1 line as you will see but there will be many rows of summary data

Whats the best way to do this? do i need a subform for the summary?

And I need to do it this way as not all exp appears on the income and exp and I want to be able to lay out the expenses for each site differently

Attached is the zip file, of the database the only record that has data is site code 0289S

Thanks in advance for your help

[keiath]

Hi Again

On my master form I have a subform called invoices this is tied by Site Number to the record on the form which is has the following important information, site code. group code, exp code an amount.

On another subform via a query I have a summary of all the invoices by exp code and group code.

On another subform I need to create a Income an Exp.

I have two combo boxes 1 for the Group Code, and another for the expense code what I want it to now do is look up group code – exp code = Total amount. There is currently only 1 line as you will see but there will be many rows of summary data

Whats the best way to do this? do i need a subform for the summary?

And I need to do it this way as not all exp appears on the income and exp and I want to be able to lay out the expenses for each site differently

Attached is the zip file, of the database the only record that has data is site code 0289S

Thanks in advance for your help

Can anyone help?