How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36777
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have an Access 2010 database of members. Each member record

This answer was rated:

I have an Access 2010 database of members. Each member record contains a field for the 'County' in which they live. How can I design a query to only show those who live in counties X, Y, and Z?
This is how

Select * from TABLE where COUNTRY in ('x','y','z')

Let me know if you have any difficulties please
Customer: replied 4 years ago.

Is that the string I copy and paste into the field?

You need to alter it Jeremy

Select * from TABLE where COUNTRY in ('x','y','z')

TABLET is replaced with your Table Name

Country needs to be the field name in the table

Than it is ok

Richard and 4 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions