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