Creating A Query Advise

  • Thread starter Thread starter Dermot
  • Start date Start date
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.
 
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
'====================================================
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Criteria No Longer Works 1
Using IIF In Query Criteria 4
Use In() Expression as Query criteria with guts from Function 1
Delete Query: Could not delete from specified tables 0
Data entry denied in a query. 6
Query update problems 2
search multiple criteria 0

Back
Top