DLookup syntax error- can't figure out what I am doing wrong.

[Need_Excelhelp]

Hi,

I am a complete newbie at Access. Through google, I learned that DLookup is the access version of Vlookup.

I tried the following function in various ways and am getting syntax- (missing operator) in query expression '[begDate]=9/28/...' error.

1. net: DLookUp("[ccFee]","ccFee","[begDate] =" & [timestamp])
2. net: DLookUp("[ccFee]","ccFee","[begDate] ='" & [timestamp]&"'")
3. net: DLookUp("[ccFee]","ccFee","[begDate] =" & Chr(34) & [timestamp] & Chr(34))

In the first option, I am doing exactly the same as this YT tutorial.

However, I have no idea what I am doing wrong and why I am getting the same errors. I also tried by adding and deleting spaces between characters.

Is there any other way to do a "Vlookup" in Access?

I would appreciate all your help. Thank you so much in advance.

Regards,

N_EH

 

[Need_Excelhelp]

Hint: Take a look at "Aggregate (Totals) Queries".

If you run into questions, just be sure to post a new thread (since it is a new topic).

Have a good weekend!

Sure. Thanks and you too!