Quizzes & Puzzles2 mins ago
MS Access Function Help
3 Answers
In the MS Access help system is there a list of built in functions somewhere. I have search without sucess.
Thanks
Thanks
Answers
Best Answer
No best answer has yet been selected by GuavaHalf. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Not sure about in the Access help, but try this.
Leigh.
EXTERNAL LINKS:
http://www.filex.com/htmlhelp/traxhelpMS_Access_Functions.html
FileExpress Page
Seems to be a glaring omission doesn't it? If you choose the online help, there is an alphabetical list of functions.
With the offline help, the closest I could get was a search on functions and then choose the rather long-winded "Comparison of functions between Visual Basic for Applications and SQL Server" etc.
Not sure whether this is what you want, but try this.
When in Query design view there is an �Expression Builder� button (it looks like a "Wizard" button - a magic wand with dust underneath it).
If you click this button you will see a dialogue box. In the bottom left hand panel of this box you will see a number of folders (�Tables�, �Queries�, �Forms� �Reports�, �Functions� and others). Expand the Functions folder and you will see (in the right hand panel) a list of all the available functions. The panel in the centre bottom allows the user to select groups of functions. There is help on most of these functions available via the usual MS-Access Help system.
Let me know if this is not what you need.
When in Query design view there is an �Expression Builder� button (it looks like a "Wizard" button - a magic wand with dust underneath it).
If you click this button you will see a dialogue box. In the bottom left hand panel of this box you will see a number of folders (�Tables�, �Queries�, �Forms� �Reports�, �Functions� and others). Expand the Functions folder and you will see (in the right hand panel) a list of all the available functions. The panel in the centre bottom allows the user to select groups of functions. There is help on most of these functions available via the usual MS-Access Help system.
Let me know if this is not what you need.