formula imput in access data bases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to imput a simple addition formula in access databases how do i go
about doing this?
 
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]
 
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]
 
Back
Top