Creating A Query Advise

D

Dermot

If I have a table of contact details which contains a Yes / No field...for
whatever reason...

What Query type / Criteria should I enter should I use to return a dynaset
of all the Yes records.
 
J

John Spencer

Use True as the criteria

Field: SomeYesNo
Criteria: True



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
D

Dermot

Hi John

Thanks for the explanation......It's been quite a while since I looked at
access and I just couldn't work out the answer....I knew it was
obvious......think logic! true or false.

I was trying for example: Like "“Yes*â€"......but that returned blanks?

If you have any further comments / use full query tips I would appreciate
you posting to kick start my memory.
Thanks again.
 
Top