applying a calculation to a table

[Dan]

Dear all,
In a table I need to apply a calculation (a multiplication, albeit a rather
complicated one with lots of iif statements) whereby I aim to mulitply the
value in one field (called length) to many (~50) other fields in each record.
The length value in each record is different, so each recieving field needs
to be multiplied by the length value in its record. Ideally I would like a
make table query, so I can have all the new calculations in parallel to the
raw data (as I need to summarise this new data as well). I have tried having
the calculation string in a new field representing each of the fields I want
to be mulitplied, but the whole thing was to complex and access refused it.
If i hlave the number of fields that I aply the calculation too it works fine
(however I need them all done!)
Is there a simpler way of designing this? Any suggestions gratefully
received!
cheers, Dan

 

[Rick B]

Answered in your OTHER POST.

PLEASE do not post the same question to more than one table. It means that
more than one person may spend time typing a response only to find that you
already have an answer in another newsgroup.

If you feel your question fits two groups, post ONE message to both groups
by entering both newsgroups in the "Newsgroup" field when posting. This
will place a copy in both (or more) newsgroups. If an answer is posted in
one, it will be seen in the others. This will allow folks to see where your
issue stands regardless of which newsgroup they are reading.

For more information...
Netiquette FAQ
http://www.mvps.org/access/netiquette.htm