Math functions in Access

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

Guest

I have a field in an Access 2000 table that I need to be the sum of two other
fields. I have one field named "Price" that I would like to me the total of
the fields "mkt" and "mktref". Thanks.
 
Hi William

In a query
Price:[mkt]+[mktref]

In a form (Price field's record source)
=[mkt]+[mktref]

Hope this helps
 
William said:
I have a field in an Access 2000 table that I need to be the sum of
two other fields. I have one field named "Price" that I would like
to me the total of the fields "mkt" and "mktref". Thanks.
Click to expand...

It is incorrect to store values in a table that can be derived from other
values. Put your calculation in a query based on your table and include all
other fields. Then just use the query instead of the table any place you need
the total.
 
Thank you very much for your help.

Wayne-I-M said:
Hi William

In a query
Price:[mkt]+[mktref]

In a form (Price field's record source)
=[mkt]+[mktref]

Hope this helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do


William said:
I have a field in an Access 2000 table that I need to be the sum of two other
fields. I have one field named "Price" that I would like to me the total of
the fields "mkt" and "mktref". Thanks.
Click to expand...
Click to expand...
 
Thank you very much for your help.

Rick Brandt said:
It is incorrect to store values in a table that can be derived from other
values. Put your calculation in a query based on your table and include all
other fields. Then just use the query instead of the table any place you need
the total.
Click to expand...
 
Back
Top