1 Report out of 2 forms

1 Report out of 2 forms

Hi all,

I created a form where I can indicate a capacity per factory, per month (form 1). It looks the following:

 

Month

Factory

Qty

01-Aug-2012

Factory 1

100000

01-Sep-2012

Factory 1

250000

 

In another form we enter volumes per week that are forecasted so far, like shown below;

 

Date

Factory

Qty (SF)

01-Aug-2012

Factory 1

90000

01-Sep-2012

Factory 1

100000

10-Sep-2012

Factory 1

50000

 

I need to build a report where I can see e.g. how much volume has been forecasted and what the capacity for that factory was. An example is reported below

 

Factory

Month

Total forecasted

Capacity

Factory 1

August

90000

100000

Factory 1

September

150000

250000



What is the simple way to do this? Probably very simple but I am quite new to this. Thanks.

Bart