I have a report which in the detail section shows records that contain 2 date fields. On of them is named "txtDateShpd" and the other is named "txtAck_Date". The 2 control source fields from the underlying query are "DateShpd" and "Ack_Date". On the report then for each record I display "Y" if the "txtDateShpd" is <= "txtAck_Date". I display "N" if the "txtDateShpd" is > "txtAck_Date". The syntax for this Y/N field on the report in the underlying query is... OnTime: IIf([DateShpd]<=[Ack_Date]
But I also show the qty shipped for each record on the report. I also sum the qty shipped for all records in the footer of the report with a field named "txtTotalQtyShipped". The syntax for this field is =Sum([ShipQty]) . This detail and footer sections of the report are working just fine.
But my issue is that I need to sum the qtys for the "Y" records on the report in the footer section and also need to sum the qtys for the "N" records on the report. How do I do this?
I'm attaching a jpg file of the report to show you what I'm talking about.