fields that calculate

[Sharon Voit]

I am trying to set up a membership database that also
caluculates. I am used to using claris works where I can
program simple caluculations as a field. Ex. multiply to
get sales tax. Subtracting deposits and adding up total.
How can I do this in access?

 

[Dave]

Hi Sharon,
Firstly, you should note that calculations shouldn't be
made in tables. Set up a new query based on the tables
that hold the information and drag in the required fields.
In an empty column in the design grid, type a field alias -
for example SalesTax, followed by a colon, followed by
the formula. For example:
SalesTax:[Price]*1.1
This formula would show a result of the field named Price
with a 10 percent mark up.
A good source of info is found in the online help in
Access. On the index tab, type in queries, calculations.
You should find more on what you need in there.
Cheers,
Dave