formula imput in access data bases

R

Ruth

i want to imput a simple addition formula in access databases how do i go
about doing this?
 
G

gls858

Ruth said:
i want to imput a simple addition formula in access databases how do i go
about doing this?
Click to expand...

In Access hey are called expressions. You can build them in the design view
of a query.

Example:

[Field1]+ [Field2]
 
J

John Vinson

i want to imput a simple addition formula in access databases how do i go
about doing this?
Click to expand...

Don't try to do any formulas in Tables. A table may look like a
spreadsheet but IT IS DIFFERENT.

Instead, create a Query based on your table. If you want to add across
rows, make it a Totals query by clicking the Greek Sigma icon (looks
like a sideways M); if you want to add fields within a record, type an
expression in a vacant Field cell in the query grid, such as

TotalPrice: ([BasePrice] * [qty]) * (1.0 + [TaxRate])


John W. Vinson[MVP]
 
Top