Hi arnelgp, Thanks for looking and responding to my problem. Ancillarydata holds various data under different names so no need for criteria.
DLookUp("[Completed]","AncillaryData") works fine as standalone and so does the other part DSum("AmountPaid","InvoicePayments","ChequeNumber <>'Credit'...