loop through every record in a field

[adamgilb]

Hi guys,

I want to loop through every record in a yes/no field (intFilterCode) in a table (tblOrganisation) and set every yes (1) back to a no (0). Could anyone give me a bit of code for this please? I'm afraid I'm not much of an expert. Maybe there is an easier way to do this?

Thanks a lot

 

[Mile-O]

You don't need to do this.

Just use an UPDATE QUERY.

ie..

UPDATE MyTable SET MyField = False WHERE MyField = True;

 

[adamgilb]

Thanks very much! I knew there must be an easier way!