Resricting the amount in a query

[LEE hepworth]

Hi All
What I need is to restict different queries to say 40 entries and the other 32 entries but if this cannot be done I can resrict them all to 40 .Just need to know how. I'm using MS access 97


In English say you run a query, that will pull all the records. What I want is to run a query in say ascending order but only show the first 30 records even though there's 50 records

Is this poss?

 

[Mile-O]

What I need is to restict different queries to say 40 entries and the other 32 entries but if this cannot be done I can resrict them all to 40 .Just need to know how. I'm using MS access 97
Ta

I think you mean the SELECT TOP keywords although I can't be sure as what you've written doesn't makes sense.

ie.

SELECT TOP 40 FROM MyTable;