Math functions in Access

[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.

 

[Guest]

Hi William

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

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

Hope this helps

 

[Rick Brandt]

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.

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.

 

[Guest]

Thank you very much for your help.

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

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.

 

[Guest]

Thank you very much for your help.

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.