I dont know if it's me or what, but I always have problems with the correct syntax for the D's... You know the Dlookup, DSum,DLast and so on but I generally find the answer using Google and various forums to glean an answer. But this one has me flumoxed. My question is can I use a Dlookup within a Dsum calculation for a Textbox? If so, can any kind person indicate what I am doing wrong with the following line of code?
=DSum("AmountPaid","InvoicePayments","ChequeNumber <>'Credit' AND PaymentDate = #" & DLookUp("[Completed]","AncillaryData") & "#")
Many thanks in anticipation..
=DSum("AmountPaid","InvoicePayments","ChequeNumber <>'Credit' AND PaymentDate = #" & DLookUp("[Completed]","AncillaryData") & "#")
Many thanks in anticipation..