I have 1 table and 2 queries:
tbl_Months
qry_ForecastV
qry_ActualV
I have the ForecastV and ActualV queries linked to the tbl_Months via the month field.
Instead of getting this:
MM/YY Forecast_v Actual_v
11/16 1100
12/16 1000 1200
01/17 600 700
02/17 800
03/17 800
I get:
MM/YY Forecast_v Actual_v
11/16 1100
12/16 480330 3433244
01/17 343242 3456546
02/17 800
03/17 800
Its multiplying the 12/16 and 01/17 values many times. The other months (11/16, 02/17 & 03/17) are fine.
Any ideas?
tbl_Months
qry_ForecastV
qry_ActualV
I have the ForecastV and ActualV queries linked to the tbl_Months via the month field.
Instead of getting this:
MM/YY Forecast_v Actual_v
11/16 1100
12/16 1000 1200
01/17 600 700
02/17 800
03/17 800
I get:
MM/YY Forecast_v Actual_v
11/16 1100
12/16 480330 3433244
01/17 343242 3456546
02/17 800
03/17 800
Its multiplying the 12/16 and 01/17 values many times. The other months (11/16, 02/17 & 03/17) are fine.
Any ideas?