query design view problem

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I have a fairly simple table that I am trying to query and
am having problems with one of the parameters. There is a
field that simply holds a Yes or No. I am querying the
table and wanting only rows where this field is Yes. In
the design view, I set the criteria to "Yes" (Y and N are
capitalized in actual field)and run the query. Most of the
rows returned are correct, but there are No's sprinkled
throughout the results. I have checked the fields in the
actual table and they look fine. Has anyone encountered
this problem? Any suggestions?
 
Can you post the SQL for your query? Does the field contain the values "Yes"
and "No", or does it contain "Y" and "N"? Is it a Text field or a boolean
(Yes/No) field?
 
I have a fairly simple table that I am trying to query and
am having problems with one of the parameters. There is a
field that simply holds a Yes or No. I am querying the
table and wanting only rows where this field is Yes. In
the design view, I set the criteria to "Yes" (Y and N are
capitalized in actual field)and run the query. Most of the
rows returned are correct, but there are No's sprinkled
throughout the results. I have checked the fields in the
actual table and they look fine. Has anyone encountered
this problem? Any suggestions?
Click to expand...

What's the datatype of the field? Is it Text, or is it Yes/No? IF the
latter, what's actually *stored* is -1 for Yes, 0 for No.
 
Back
Top