I need help! I am not too familiar with VB but have been using access a little bit. I have 3 queries where I calculate Labour Cost, Materials Cost and Allocate Overhead cost to these from a construction company(See image).

All the costs are grouped by Job numbers.

I'd like to make a report that would show me the total amount of costs per job, per week.

(I tried making a query that bind these three qureries together and it sourt of worked until I added the dates, then everything got messed up and the total sums got too much..)

I'd appreciate any help a lot!



Cheers,



Arni

You might want to check out using sub-reports

You might want to check out using sub-reports

Hm.. I'll try to find some info on that then...

Thank you very much!


Arni