DLookup with 3 Criteria??

[mugman17]

Is there a way to do a DLookup with 3 criteria, I have tried this with no luck...


=DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [Date]=#" & [TodaysDate] & "#" And "[MonthForward] = #01/01/2004#")

HELP!

 

[scottfarcus]

Remove the double quotes after the closing # on TodaysDate and between the AND and MonthForward. Should work if it looks like this...

=DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [Date]=#" & [TodaysDate] & "# And [MonthForward] = #01/01/2004#")

 

[mugman17]

Works perfectly, thanks for your help.