Calculations In Access

[bajanboost]

Trying to make a calculation in Microsoft Access that would allow m
to take the currency in one field, and multiply it by the quantity o
an item in another field and place this calculated information in
new field

 

[Doug Robbins]

This is really a question for an Access newsgroup, but all you need to do is
create an Update Query that updates the "new field" with the product of the
other two fields. If those fields were named "rate" and "quantity" you
would use the following expression

[rate]*[quantity]

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jezebel]

Then again, it's very bad practice to add derived fields.

This is really a question for an Access newsgroup, but all you need to do
is create an Update Query that updates the "new field" with the product of
the other two fields. If those fields were named "rate" and "quantity"
you would use the following expression

[rate]*[quantity]

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Trying to make a calculation in Microsoft Access that would allow me
to take the currency in one field, and multiply it by the quantity of
an item in another field and place this calculated information in a
new field.

 

[Doug Robbins]

Agreed. A Select Query would do the job equally as well without any
drawbacks.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Then again, it's very bad practice to add derived fields.

This is really a question for an Access newsgroup, but all you need to do
is create an Update Query that updates the "new field" with the product
of the other two fields. If those fields were named "rate" and
"quantity" you would use the following expression

[rate]*[quantity]

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Trying to make a calculation in Microsoft Access that would allow me
to take the currency in one field, and multiply it by the quantity of
an item in another field and place this calculated information in a
new field.