using formula

Forum home » Delegate support and help forum » Microsoft Access Training and help » Using formula

Using formula

resolvedResolved · 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


 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.08 secs.