Macro or Query for new record

  • Thread starter Thread starter Todd
  • Start date Start date
One way is to pull your records to a query and sort so the newest record is
first. I did this by sorting my autorefnumber descending.

Then in the Query's properties, set the "Top Value" to equal 1.

This will pull only the highest ref number.

Rick


How can I pull only the newest record into a report?

Todd
 
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

Newest record retrieval? 1
Print a report from a form based on a query 4
Form fields don't need to always be filled in 1
Adding new record in form/not pulling from combo 6
Access Automatically Send a notification email once a record is added 0
Running a report for a specific record from a form 6
Combine Duplicates in Query 0
Subquery in Form 1

Back
Top