first 200 records

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi,

I would like my query to pull out the first 200 records. Would you show me
the criteria or how to make it works?

Thanks
Chi
 
I would like my query to pull out the first 200 records.
You must remember that records are not in any set order in the table. You
need to sort them if you want a perticulair first 200.

In design view click in the icon that has 'All ' showing with a down
arrow on the right and enter 200.
 
Thank you so much!
It works perfectly.

KARL DEWEY said:
You must remember that records are not in any set order in the table. You
need to sort them if you want a perticulair first 200.

In design view click in the icon that has 'All ' showing with a down
arrow on the right and enter 200.
Click to expand...
 

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

Criteria for an email address fied 2
Between Date 10
criteria 7
200 results per page 2
Unmatached in 1 Table 1
Criteria 3
Parameter query 3
Between dates 7

Back
Top