this is the SQL statement
PARAMETERS [Forms].[Frm_PartsMasterLots].[SelectedModel] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedAssyItem] Text ( 255 ), [Forms].[Frm_PartsMasterLots].[SelectedPN] Text ( 255 );
TRANSFORM Sum(Qry_PageCrosstab_Xs_S2.QtyPerCar) AS SumOfQtyPerCar
SELECT Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode
FROM Qry_PageCrosstab_Xs_S2
WHERE (((Qry_PageCrosstab_Xs_S2.TheSelectedLot) Between [AssyItemStartLot] And [AssyItemEndLot]))
GROUP BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo, Qry_PageCrosstab_Xs_S2.Description, Qry_PageCrosstab_Xs_S2.DispoCode, Qry_PageCrosstab_Xs_S2.AssyItemStartLot, Qry_PageCrosstab_Xs_S2.AssyItemEndLot
ORDER BY Qry_PageCrosstab_Xs_S2.AssyPage, Qry_PageCrosstab_Xs_S2.PartNo
PIVOT Qry_PageCrosstab_Xs_S2.MdlCd In ("CR65.A7","KU65.A7");
the a/m query is ready by a report so the column heading is fixed
so, how can these model code ("CR65.A7","KU65.A7") as a column heading automatically changed when i choose a different SERIES
thanks in advance
__._,_.___
Posted by: youssef2309@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar