Clearing yes/no fields

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clearing fields	BruceM	Microsoft Access Form Coding	7	3rd Apr 2006 12:38 PM
Clearing Fields In A Form	=?Utf-8?B?UGF1bEh1bW1lbA==?=	Microsoft Word Document Management	2	15th Jun 2005 04:09 PM
Clearing Fields	=?Utf-8?B?TWFubnkgQ2hvaGFu?=	Microsoft ASP .NET	2	20th Oct 2004 06:19 PM
Clearing fields on close	=?Utf-8?B?TmVpbCBDYXNo?=	Microsoft Access Form Coding	2	29th Sep 2004 01:45 PM
Clearing fields on a Form	MichaelR	Microsoft Access Form Coding	2	12th Sep 2003 11:44 PM