Access Function Primer? 1

[xweyer]

Does anyone know of any web resources for the built in functions in Access?

I'm looking for an overview of each function and samples/examples of each functions use.

I've found a few sites that cover the most common functions but many others are not covered at all.

 

[PHV]

Why not simply use the F2 and F1 keys while in VBE ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[xweyer]

Thanks.

That is very helpful

I don't ordinarily work in the VBE and didn't know that was there. It's kind of strange that the Expression Builder doesn't supply similar help.

One thing I would like to be able to do is print out all the help on functions usable through Expression Builder. I know that I can do this function by function but if there is such a resource out on the web I'd like to know about it.

A last question. Is there any difference between functions like Str and Str$ or Chr and Chr$, etc. or are these just alternate syntax for the same function. I notice that although VBE Help has separate listings for both types of functions the help displayed is exactly the same.

 

[PHV]

I think that Str returns a variant of subtype string while Str$ returns a string.
I personally NEVER use the xxx$ dollar functions because I think, perhaps badly, that the variant versions handle Null values better.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244