Need_Excelhelp
New Member
- Joined
- Oct 14, 2014
- Messages
- 22
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
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