Limit # of records

  • Thread starter Thread starter Eric Blitzer
  • Start date Start date
E

Eric Blitzer

In the properties section of a query you have the ability
to limit number of records. No matter what number I put I
still get all the records. Can anyone explain this?

Thanks

Eric
 
Are you sorting the records by some column/columns so that Access can decide
which ones to return? When you limit records Access will return all ties based
 
You must log in or register to reply here.

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

Limiting Records in an Update Query 5
Restrict number of records returned by query on form 2
AND query 4
Delete Query: Could not delete from specified tables 0
Limit action query 1
Query only records with checked box 3
limit query to top 'n' records 3
where clause 2

Back
Top