Find the Latest Update for Each Product in Microsoft Access
Question details
Find each product's most recent update and return the associated update details.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A database contains a product information table and multiple update records for each product.
- Observed behavior
- The desired query returns each product with its latest update date, type, and description.
Confirm that Product_Information and ProductUpdates share a product_name field and that update_date contains date/time values. Adjust the table and field names in the query if your database uses different names.
Use a Correlated Subquery to Find Each Product's Latest Update
Use this query to return the update details associated with the maximum update date for each product.
In Microsoft Access, select Create > Query Design, then switch to SQL View.
Replace any existing SQL with: SELECT PI.product_name, PU1.update_date, PU1.update_type, PU1.update_description FROM Product_Information AS PI INNER JOIN ProductUpdates AS PU1 ON PI.product_name = PU1.product_name WHERE PU1.update_date = (SELECT Max(PU2.update_date) FROM ProductUpdates AS PU2 WHERE PU2.product_name = PU1.product_name);
Select Run and check the results. To include more product information, add the required PI field names to the SELECT list.

Track Product Updates in WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with office documents and spreadsheet-based update lists. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files, though it does not fix or run Microsoft Access queries.

Frequently Asked Questions
Why does the query return more than one update for a product?
The query returns every update whose update_date equals that product's maximum date. If dates tie, use a unique update ID as an additional tie-breaker to select one record.
Why are products without updates missing?
The INNER JOIN includes only products with matching update records. To include products without updates, save a query that returns the latest updates, then left join Product_Information to that saved query.
Can I include other product fields in the results?
Yes. In SQL View, add fields from Product_Information to the SELECT list using the PI alias, such as PI.region or PI.product_status, if those fields exist in your database.
Why do older updates appear when I add update details to a totals query?
Grouping by update_type or update_description can create separate groups for older updates. Calculate Max(update_date) by product first, then join the result back to ProductUpdates on both product_name and update_date to retrieve the associated details.




