Well for the third time of asking - how are you creating the remarks field? What is the SQL in the query ?
Text please, not a picture.
how are you creating the remarks field?
- The remarks in my report come from my database, which i set the data field in my database for remark as "long text" as my remarks is very long.
What is the SQL in the query ?
SELECT mxd.FabricDelivery, mxd.Fabrication, mxd.Width, mxd.FinishedGoods, mxd.Colour, mxd.LabDipCode, Sum([mxd.GrossWeight]) AS TotalGrossWeight, Sum([mxd.NettWeight]) AS TotalNettWeight, Sum([mxd.Yds]) AS totalYds, mxd.Fabrication, mxd.MXDPO, Sum([mxd.Loss]) AS TotalLoss, First([mxd.Remarks]) AS Remarks, Min(mxd.GLGPO) AS MinOfGLGPO
FROM mxd
GROUP BY mxd.FabricDelivery, mxd.Width, mxd.FinishedGoods, mxd.Colour, mxd.LabDipCode, mxd.Fabrication, mxd.MXDPO
HAVING (((Min(mxd.GLGPO))=[Enter 1st GLGPO] Or (Min(mxd.GLGPO))=[Enter 2nd GLGPO]));