Data From Previous Record

[Grieve1]

Hi I am trying to display the result of a field from a previous Record depending on 2 fields criteria e.g. Field name is "Payment" depends on fields "CompanyName" and "paymentNumber", Was trying to do a dlookup("[Payment]","qryPaymentCert","[PaymentNumber]="&[PaymentNumber]-1 and "[CompanyName] =""" & [CompanyName] & """") individually they work but not together any assistance would be gratefully Appreciated

 

[PHV]

Perhaps this ?

DLookUp("Payment", "qryPaymentCert", "PaymentNumber=" & [PaymentNumber]-1 & " AND CompanyName='" & [CompanyName] & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Grieve1]

Thank you so much with just a little tweaking all is working great