Query record with most recent date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database contains a new record for each labor purchase created or ammended.
Each record is characterized by a purchase order number, item description,
amount, and date.

I need to create a query criteria that only pulls in the latest record for a
given purchas order number.

My query now has fields for:
purchase order number
 
Richard

Create a new query in design mode. Add the table that holds the purchase
order data.

Add the Purchase Order Number field, and the field that holds the date
(hint: don't name this field "Date", as that is a reserved word in Access -
you could call it DateUpdated...)

Change the query to a Totals query, using the button that looks like a "3"
(greek sigma). GroupBy the Purchase Order Number, and use Maximum for the
date field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top