Add Fields to Report

[Thecherub]

Arrgh This report is driving me nuts

I've got most of it but these last two items are giving me headaches.

I've got a report with sub reports for Time off.

Time off current (TOC)is one sub report with attendant query
Time off History (TOH)is the other sub report with it's attendant query

both are on different tables.

I need to add to the main report two fields Vacation Time used and remaining. The remaining is easy its the the used that is driving me nuts. TOC and TOH are both list boxes with the item Vacation as one of the items. I need to add them together and then subtract that number from the Vacation allotment (in another table) to give the remaining vacation availble.

I don't know if my design is faulty or my thinking process is. I can't wrap my head around this.

please help



In both the TOH

 

[Lister]

Have you tried joining the two tables (or queries) in a different query then doing the calculation their. And use the resultant record set to make up your last sub report?

Just an idea.

 

[Thecherub]

tried

I've tried that the problem is i'm trying to avoid a 3rd subreport i've already got 2.