Clear one field, multiple records 1

[powerpro]

Is it possible to do this?

I have a form for personnel accountability which I run multiple times a week (We do this a lot in the military).

Basically I have a form which has a yes/no drop down box [accounted] that I would like to clear on each individual record once I'm done. Basically reset the field to null till I need to account for personnel the next time.

Any assistance would be appreciated.

 

[Remou]

Hi
How about a query (SQL view)?
UPDATE TableToUpdate SET TableToUpdate.Accounted = Null;

 

[powerpro]

Thanks Remou, that'll do it. Certainly appreciate your speedy response too.