Run a code on each record

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have a table in a query and I would like to run a code on each record
and then stop after the last record. What would be the easy way
of doing this?
 
Jay said:
I have a table in a query and I would like to run a code on each record
and then stop after the last record. What would be the easy way
of doing this?
Click to expand...


Depends on what you're trying to accomplish. If you just
want to calculate a value based on other fields in the same
record, use a calculated field. For simple calculations
just use an expression, for more complicated calculations
create a function in a standard module a call it from the
query.

If you want to calculate a value that uses values from all
the records, then you should use a Group By (Totals) type
query.
 
Back
Top