In Acess 2003 how do I rename a Yes/No Field?

's Computer Specifications

I am trying to change Y/N to Smoker/Non-Smoker so I can use that text in Mail
Merge letters.
--
DCG

's Computer Specifications

Try something like this in a query:

Field: IIF([FieldName] = 0, "Non-Smoker", "Smoker")

where [FieldName] is the name or your Yes/No field. Make the appropriate
substitution for the name.

Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"dg2k" wrote:

> I am trying to change Y/N to Smoker/Non-Smoker so I can use that text in Mail
> Merge letters.
> --
> DCG

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default the field - Search Fields As Formatted in Acess 2003	vintang99	Microsoft Access	1	13th Jan 2010 03:44 PM
Acess 2003 concurrent with acess 2007	Scott	Microsoft Access	4	3rd Mar 2009 04:36 AM
How do I rename a table in Acess 2007?	pbirch16	Microsoft Access	5	15th Aug 2008 08:46 AM
What problems should we expect with Acess 2003 db on aa Acess 2000 ?	Will	Microsoft Access	5	23rd Mar 2006 12:14 AM
how to copy a data field content into clipboard in Acess 2003?	=?Utf-8?B?amlubHN1aQ==?=	Microsoft Access VBA Modules	2	5th Mar 2005 01:12 AM