Limit # of records

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
 
J

John Spencer (MVP)

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
 

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

Merge Excel file into Word Document 3
How do I clear a form? 0
Copy previous record into form field 0
Old question regarding Access Templates. Any up to date answers, please 2
Paragraph numbering in Word 1
Mail Merge skipping records/sending one at a time 0
Infopath file size exceeds the limit allowed and cannot be saved 0
M.S. Word 365 1

Top