I recently started using Access. I noticed that a lot of the functions I'm familiar with from Excel are here: VLOOKUP, OFFSET, DOLLAR, etc. -- when/where can we use them in Access? I tried inserting them into a Module, but got errors.
Functions will work almost anywhere provided you use them as functions ... in Tables, Forms. Queries, Macros, Modules etc.
Type the function name, place the cursor in the middle of it, then hit F1 for help. If the function exists in Access then you'll see the semantics and the appropriate syntax! If it doesn't then you won't.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.