calculating fields

[Guest]

i am trying to multiply two fields in tables
i have three fields days, fee, and payments i wont to multiply days by fee
to get
payment is it possible to done this in tables or do i have to set a query or
a report
to do this i am using access 2003

 

[Wayne Morgan]

No, this can't be done in a table. The calculation can be done in a query,
form, or report. It is also not normally recommended to store the result of
a calculation back to the table. Instead, just do the calculation when you
need it.

 

[Joseph Meehan]

i am trying to multiply two fields in tables
i have three fields days, fee, and payments i wont to multiply days
by fee to get
payment is it possible to done this in tables or do i have to set a
query or a report
to do this i am using access 2003

Tables are just buckets of data. They don't compute.

Unless you need the results of the calculation saved for historic
reasons and the data used in the calculation will or may change (and you
don't want the result changed) then don't put the result in a table. You
just compute it anytime you need it using a query, report or form.

 

[Larry Daugherty]

Multiply in your forms or reports. Tables are just containers. They
may look like spreadsheets but there's nothing active going on there.

By the way, don't store the calculated results back into a table.
Always recalculate them when you need them.

HTH