Calculations In Access

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
Mon May 02 03:00:43 CDT 2005

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
"bajanboost" <sales@bajanboost-dot-com.no-spam.invalid> wrote in message
news:HoKdnfLODofRJ-jfRVn_vg@giganews.com...
> 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.
>

Jezebel
Mon May 02 03:57:44 CDT 2005

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


"Doug Robbins" <dkr@REMOVEmvps.org> wrote in message
news:OJl4K0uTFHA.3188@TK2MSFTNGP09.phx.gbl...
> 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
> "bajanboost" <sales@bajanboost-dot-com.no-spam.invalid> wrote in message
> news:HoKdnfLODofRJ-jfRVn_vg@giganews.com...
>> 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
Mon May 02 10:40:35 CDT 2005

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
"Jezebel" <warcrimes@whitehouse.gov> wrote in message
news:%237JhwTvTFHA.1468@TK2MSFTNGP10.phx.gbl...
> Then again, it's very bad practice to add derived fields.
>
>
> "Doug Robbins" <dkr@REMOVEmvps.org> wrote in message
> news:OJl4K0uTFHA.3188@TK2MSFTNGP09.phx.gbl...
>> 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
>> "bajanboost" <sales@bajanboost-dot-com.no-spam.invalid> wrote in message
>> news:HoKdnfLODofRJ-jfRVn_vg@giganews.com...
>>> 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.
>>>
>>
>>
>
>