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

formulas

ResolvedVersion 2007

Jennifer has attended:
Access Intermediate course

Formulas

What is the fomrat or pattern to writing formula in access tables?

RE: Formulas

Hi Jennifer, thanks for your query. The best way to do that would be a calculated field in a query. Have a look here:

http://599cd.com/tips/access/calculated-query-fields/

Hope this helps,

Anthony

RE: Formulas

I was referring to the formula that can added to the expression builder. Do the components of these formulae have to be in a particular order?

Thu 29 Dec 2011: Automatically marked as resolved.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

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.