Yes/No Data type field and queries

S

stacymae

Hi,

I have a yes/no field in my query I qould like toenter a criteria that would
only display fileds that are "No" or unchecked. Do you know what I would need
to enter to do this? My filed is Active/Inactive, I only want to display
active entries.

Thank you
 
I

inertia

I am having a similar problem

In the criteria field of the query buiilder, I am entering the Statement

(SELECT resolved From tblflag WHERE resolved=False;)

However I keep getting a message that at most one record can be returned.. I
KNOW this is incorrect. any ideas!?
 
V

Van T. Dinh

From the description, I guess you use the posted String (SubQuery) as the
right side of a Boolean expression where the left side is a Field name. In
this case, JET expects your SubQuery to return a single value, (i.e. a 1 row
x 1 column return). However, you SubQuery returns more than 1 row (1 row
for each Record that has resolved = False) and hence you get the error.

If you need further help, post relevant Table details, what you want the
Query to select and the *whole* SQL String of your attempted Query.
 
Top