WorksSheetFunctions

M

mcl

I find that when I go into MS Access Help (that is access help NOT excel) I
find listings for Worksheet Functions. One is Today(). In access it doesn't
work. It gives an undefined function. If course "=today()" works fine in
excel. Why do I see excel stuff in access. Noticed I couldn't find iif in
access help. It has "if " which of course works in excel. Why is help
useless.
 
M

Michel Walsh

Hi,


In Access, you use Now().


The Help system may list Excel functions while you are in Access, indeed,
mainly if you use a keyword that does not exists, say, in Access.


In Access 2003, with "Microsoft Office Access Help", in the Database Window
view (not in VBE), looking for "Today", I got, indeed, a reference to use
=Now(), in the first item found.


Hoping it may help,
Vanderghast, Access MVP
 
Top