Run a code on each record

[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?

 

[Marshall Barton]

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?

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.