Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

using formula

ResolvedVersion 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:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.