Dear Experts,
I have below SQL Statement (Crosstab_Query) which is working fine! The Support I need here is,
In the Output view after Part_Number Column, I would want few values to be looked up (As Column) from another table keeping Part_Number as Lookup_Value Reference.
Table Name is FG_PN_LISTS from which following data’s to be looked up!
Crosstab Query output view must in below sequence
1st Column is Part_Number from Crosstab (As shown in below SQL Statement)
2nd Column has to be “Group” Column Value from FG_PN_LISTS
3rd Column has to be “Planner” Column Value from FG_PN_LISTS
4th Column has to be “Lead_Time” Column Value From FG_PN_LISTS
5th Column onwards balance Result from Crosstab (As shown in below SQL Statement)
Note:
Incase Lookup value Part_Number does not exist in FG_PN_LISTS Table, The cell has to be updated with “New”
Looking forwarded your amended SQL Query which meets my above expected Result!
Code:
PARAMETERS [Forms]![MENU]![FR_DATE] DateTime;
TRANSFORM Sum([ZVRR_TO_FR].CRD_Qty) AS SumOfQty
SELECT [ZVRR_TO_FR].Part_Number
FROM ZVRR_TO_FR
GROUP BY [ZVRR_TO_FR].Part_Number
PIVOT [ZVRR_TO_FR].CRD_Month;
Thanks & Regards,
Rajeshkumar R