Hi Richard,

For the life of me I can't get this DLookup to work can you please advise where I've gone wrong in this:
ContactNotes: DLookUp("Notes","ContactT","CustomerID=" & [CustomerID] & "AND DateTime=#" & [MaxOfDateTime] & "#")

This returns an error every time.
Thanks
Lynda

---

Reply from Richard Rost:

You're missing a space in a critical spot.

ContactNotes: DLookUp("Notes","ContactT","CustomerID=" & [CustomerID] & "AND DateTime=#" & [MaxOfDateTime] & "#")

Can you spot it?

Try replacing the field variables with values...

ContactNotes: DLookUp("Notes","ContactT","CustomerID=100AND DateTime=#1/1/2001#")

See it now?