Criteria Problem

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

How do I write the criteria if I want only names that start with A and B and
C.

Or the first 500 records in one query and records 501 to 1000 in another
query.

Thanks in advance
Richard
 
Richard,

I assume you meant A or B or C.
Like "[A-C]*"

As regards the first 500 or the next 500, on what basis is Access
supposed to know what the first 500 means? Do you have a field the
value of which determines which are included and which are not?
 
In the Criteria row of your query, under the text field try:
(Like 'A*') Or (Like 'B*') Or (Like 'C*')
Note that you must use OR.
There are no names that start with A AND also start with B.

While in query design view, you can open the Properties box (View menu) and
set the Top Values to 500. This gives you the first 500 records (slightly
more if there is a tie). There is more work in retrieving the following
groups of 500 and whatever after each of the previous ones and any ties.
 
Hi

Thanks to both of you for your help. I gave it a thought and getting the
data by the bulk of 500 is not practical. I will stick by the a-c criteria.

Thanks again

Richard

Steve Schapel said:
Richard,

I assume you meant A or B or C.
Like "[A-C]*"

As regards the first 500 or the next 500, on what basis is Access
supposed to know what the first 500 means? Do you have a field the
value of which determines which are included and which are not?

--
Steve Schapel, Microsoft Access MVP

Hi

How do I write the criteria if I want only names that start with A and B and
C.

Or the first 500 records in one query and records 501 to 1000 in another
query.

Thanks in advance
Richard
Click to expand...
Click to expand...
 
Back
Top