98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Using formula
Using formula
Resolved · High Priority · Version 2007
Dan has attended:
Access Introduction course
Excel Intermediate course
Using formula
How to use formula in Access
RE: using formula
Hi Dan
Thank you for your question
Access has an array of functions that can be accessed from the expression builder. They can be inserted into a query or text box.
Select the object that is to hold the function, then click on the expression builder button.(This has a magic wand icon)
On the right hand side of the expression builder, there are a series of folders; double click on the "function folder" and then double click on "built in functions". You are then presented with a list of function categories, and then the actual functions.
You can then apply the relevant function. The details of this application depends upon the function in question.
If you have a specific function in mind, please let me know and I will give you guidance on this
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |