Hi,
I've got the following record source for a report I'm working on:
SELECT [PRODUCT].[PROD_GRADE], [PRODUCT].[PROD_DESC], [GRN].[GRN_CODE], [GRNLINES].[GRN_PROD_CONV_QTY], [GRNLINES].[GRN_PROD_UNITPRICE], [ORDERS].[ORD_CODE], [ORDERS].[ORD_DATE], [ORDERLINES].[ORD_PROD_WEIGHT]...