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
 
Back
Top