first 200 records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chi - 21 Mar 2008 21:28 GMT

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

Reply to this Message

KARL DEWEY - 21 Mar 2008 22:26 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks
> Chi

Reply to this Message

Chi - 24 Mar 2008 14:18 GMT

Thank you so much!
It works perfectly.

> >>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
[quoted text clipped - 10 lines]
> > Thanks
> > Chi

Reply to this Message