[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