[AccessD] Criteria Question

Thanks Stuart that is what I needed, works excellent. 

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Tuesday, February 14, 2006 3:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Criteria Question

On 14 Feb 2006 at 14:34, Gowey Mike W wrote:

> Within my table I have a field that is set to Yes/No format.  I am 
> attempting to create a query that prompts the user to enter Yes or No 
> as a criteria for this field.  Everytime I prompt the user and they 
> enter Yes or No in the prompt box, they get an error of
> 
> "This expression is typed incorrectly, or is to complex to be 
> evaluated."
> 

Set the criterion to "=IIf(["Yes or no"]="YES",True,False)"


--
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com