Newbee -- when can you use Wooksheet functions?

[rcoutts]

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.

Thanks!
Rich

 

[dawnd3]

Hi there, you can use some of them in in the "field" field of a query, or in a "text box" field in a form or report.
Dawn

 

[xeotech]

Hmmm!

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.

As ever experimentation is the byword.

Regards,


Chris
Xeotech