View Single Post
  #2  
Old March 14th, 2010, 09:01 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Clearing yes/no fields

Do an update query and set the fields to No or 0 (zero).

Make a copy of the database or table first just in case things go wrong.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dan" wrote:

I have a yes/no field that I tag if I want to send a bill to various people.
After I have sent the bill I want to clear the field so I can use the field
at a later time. Is there a way to do this?