Dear Experts,
Need your valuable inputs on my subjected Query!
I have two Crosstab Query 1. FirmOrder_Crosstab & 2. Forecast_Crosstab
- FirmOrder_Crosstab
- First Column Contains Product Details
- Consequent column contains Month Code (MMM-YY Format) in 1ST Row and Firm Requirement (Qty) by each product in Value Field respectively
- Forecast_Crosstab
- First Column Contains Product Details
- Consequent column contains Month Code (MMM-YY Format) in 1st Row and Tentative Requirement (Qty) by each product in Value Field respectively
Concerns:
- Product & Month Code are not in Same Row & Column sequence in above Crosstab Queries, that is….
- Some of the Product which is not listed in 1. FirmOrder_Crosstab Query may be available in 2. Forecast_Crosstab Query and Vice versa
- Similarly, some of the Month Code which is not part of 1. FirmOrder_Crosstab Query may be available in 2. Forecast_Crosstab Query and Vice versa
Support Required is: -
- From above two Quires, I would like to find out a delta Qty (Value Field) by Product & Month Code.
- Expected Result must be in same as above Crosstab Query Format i.e. Product in First column and month code in Column and Delta Qty in Value Field
Note:
I am a New User to MS Access, Hence; Requesting you to provide your suggestion with more details (which any New User like Me) can understand, so that it will help me a lot to implement in my file immediately!
Looking forward your support!
Thanks & Regards,
Rajeshkumar R