Thanks again, but this is not working. It does what you thought I wanted, but not what I want.

I can not seem to work out the hierarchy from table to record to field. I don't really care which way Access thinks about things, i.e., Table.Record.Field or Table.Field.Record but I can not find (using the object browser) an object path that works either way.

So, clearly there is something I do not understand. Let me restate my need. Given a table "A" with fields "A1", "A2", ... and records 1, 2, 3, ... I want to loop through all records and examine, say, field A2.

FYI: I am somewhat hampered in my efforts because VBA Help in access does not work. Seems to work fine in other appls, but not in Access.