G
Guest
I have table that must be manipulated differently for each record. In each
record, I have a field that I have stored the manipulation necessary. For
example, one record might say "Price+Total-Shipping"(fields in the record),
while the next record might say "Price+Shipping+Taxes". What would be the
best way to loop through the records and have that manipulation done on
another field in the record?
In other words, loop through the records, look at the calculation, do the
calculation and put the result in an existing field in the record, move on to
the next.
Query? Form? What code?
Thanks so much..
record, I have a field that I have stored the manipulation necessary. For
example, one record might say "Price+Total-Shipping"(fields in the record),
while the next record might say "Price+Shipping+Taxes". What would be the
best way to loop through the records and have that manipulation done on
another field in the record?
In other words, loop through the records, look at the calculation, do the
calculation and put the result in an existing field in the record, move on to
the next.
Query? Form? What code?
Thanks so much..