dlookup "data type mismatch"

[mboe]

I get a data type mismatch when I run the following in a query:

Int: DLookUp("[amttxn]","fhlb_activity","[effectiveDate] = " & [effectiveDate] & " and [loan_no] = " & [loan_no])

It has to be something simple but I can't figure it out. Any help?

 

[FoFa]

Int: DLookUp("[amttxn]","fhlb_activity","[effectiveDate] = #" & [effectiveDate] & "# and [loan_no] = " & [loan_no])

Don't you need the #'s around a supplied (literial) date?
Also I assume Loan_No is numeric because you have no quotes around it.

 

[mboe]

Long Live the Lone Star State

Thanks FoFa. That was it. I knew it would be something simple I just spent too much time staring at it. Thanks.