first 200 records

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
 
K

KARL DEWEY

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.
 
C

Chi

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

Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Color in Visual Basic 2
Criteria for an email address fied 2
200 results per page 2
Between Date 10
How to make report 0
Between dates 7

Top