Selecting criteria in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to select only certain data to appear in one of three queries I
have created. The main table houses all the student information. I want to
sort all the names into three different queries and am using the "Between
And" selection on last name (i.e Between "A" And "N"). The problem is any
names starting with A or N do not appear. I know I can change the N to an O,
but I can't get the "A" names. Is there a better way to do this??
 
Between "A" and "O" should work for you.

You could also use the following to get all names that begin with A to N

LIKE "[A-N]*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

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

Problem with Query Criteria by IIF/Switch 1
Show data source in Union Select All Queries 2
Select Query Access V.B. Question 1
Calculating Meal Period Violations in Access 2
Modify Parameter Query 1
Criteria for a Select Query 6
Access Dcount (multiple criteria) 3
Parameter in Crosstab Query 4

Back
Top