How to run calculations on every record in a table

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a caculated set of vbcode that I want to run on each record in a
table or query. Maybe a loop and next record till it ends with the last
record.

Loop

VbCode

Next Record

I have been looking in help and google and have not found it yet.
 
I have a caculated set of vbcode that I want to run on each record in a
table or query. Maybe a loop and next record till it ends with the last
record.

Loop

VbCode

Next Record

I have been looking in help and google and have not found it yet.
Click to expand...

It's perfectly possible to put a calculated field in a Query (not in a
table, though). You don't say anything about your function or your
table structure, but you should be able to type

CalcField: MyFunction([fieldA], [fieldB])

in a vacant Field cell in a Query.

It is essential that you pass *some* table field as a paramter, even
if the function ignores it; otherwise the function will just get
called once and every record will get the same answer.

John W. Vinson[MVP]
 
Back
Top