How do I limit the returns from a query?

[Jesse Jones]

I would like to limit the number of returns from my query to 350. Can anyone please tell me how to do this is Access 2010?

(SQL or Design View)

Thanks.

[code green]

SELECT TOP 350 .......ORDER BY 'filter'

[Jesse Jones]

Duh. Thanks.

Any way I can get this to divide into x groups of 250?

[Jesse Jones]

350*. Sry.

[Rabbit]

You'll have to use a subquery in the where clause that returns top 350 unique IDs of a group.

[Jesse Jones]

Actually, I just had to type "350" in the returns box in the query setup group in the ribbon at the top. Duh. Just hadn't seen it.

Thanks for the tips!