Help with a DLookUp

[Bob V]

Haven't got this just right cant be that far away, need some HELP!
Thanks for any help....Bob
="Last Payment"
+DLookUp("BillDate"+"PaidAmount","qryAccountStatus","OwnerID=" &
[tbOwnerID])

 

[Douglas J. Steele]

If you're trying to return both the BillDate and PaidAmount in a single
lookup, use

="Last Payment"
+DLookUp("[BillDate] & ' ' & [PaidAmount]","qryAccountStatus","OwnerID="
&[tbOwnerID])

 

[Bob V]

Thanks Douglas, Is there a way to format them ie: BillDate d-mmm-yy &
AmountPaid($#,##0.00)
Thanks for your help.....Bob

If you're trying to return both the BillDate and PaidAmount in a single
lookup, use

="Last Payment"
+DLookUp("[BillDate] & ' ' & [PaidAmount]","qryAccountStatus","OwnerID="
&[tbOwnerID])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Haven't got this just right cant be that far away, need some HELP!
Thanks for any help....Bob
="Last Payment"
+DLookUp("BillDate"+"PaidAmount","qryAccountStatus","OwnerID=" &
[tbOwnerID])

 

[Douglas J. Steele]

I think you'll need to use two DLookups:

="Last Payment" & Format(DLookUp("[BillDate]","qryAccountStatus","OwnerID="
&[tbOwnerID]), "d-mmm-yy") & " " &
Format(DLookUp("[PaidAmount]","qryAccountStatus","OwnerID=" &[tbOwnerID]),
"$#,##0.00")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thanks Douglas, Is there a way to format them ie: BillDate d-mmm-yy &
AmountPaid($#,##0.00)
Thanks for your help.....Bob

If you're trying to return both the BillDate and PaidAmount in a single
lookup, use

="Last Payment"
+DLookUp("[BillDate] & ' ' & [PaidAmount]","qryAccountStatus","OwnerID="
&[tbOwnerID])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Haven't got this just right cant be that far away, need some HELP!
Thanks for any help....Bob
="Last Payment"
+DLookUp("BillDate"+"PaidAmount","qryAccountStatus","OwnerID=" &
[tbOwnerID])