RAJESHKUMAR R
New member
- Local time
- Yesterday, 18:42
- Joined
- Feb 12, 2018
- Messages
- 2
Dear Experts,
Need your valuable inputs on my subjected Query!
I have two Crosstab Query 1. FirmOrder_Crosstab & 2. Forecast_Crosstab (Attached is a Sample outcome of my Raw Data)
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:
1. Product & Month Code are not in Same Row & Column sequence in above Crosstab Queries, that is….
2. Some of the Product which is not listed in 1. FirmOrder_Crosstab Query may be available in 2. Forecast_Crosstab Query and Vice versa
3. 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.
Please refer Expected Result Table (Which I have generated) manually for better understanding!
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
Need your valuable inputs on my subjected Query!
I have two Crosstab Query 1. FirmOrder_Crosstab & 2. Forecast_Crosstab (Attached is a Sample outcome of my Raw Data)
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:
1. Product & Month Code are not in Same Row & Column sequence in above Crosstab Queries, that is….
2. Some of the Product which is not listed in 1. FirmOrder_Crosstab Query may be available in 2. Forecast_Crosstab Query and Vice versa
3. 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.
Please refer Expected Result Table (Which I have generated) manually for better understanding!
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