I have a report that I have a group for the [PROD] field. I have a query that says:
((tblScaleData.PROD)='Veg1' Or (tblScaleData.PROD)='Wood1')
Or (tblScaleData.PROD)='Vegr')
but I need Vegr to not show up in the group, but I need to add the weight associated with it and then subtract that amount from the total.
How do I add the weight associated with the Vegr product but not show it in the [PROD] Group?
((tblScaleData.PROD)='Veg1' Or (tblScaleData.PROD)='Wood1')
Or (tblScaleData.PROD)='Vegr')
but I need Vegr to not show up in the group, but I need to add the weight associated with it and then subtract that amount from the total.
How do I add the weight associated with the Vegr product but not show it in the [PROD] Group?
