Others

Find the Latest Update for Each Product in Microsoft Access

Bushra ParveenBushra Parveen Nov 20, 2026 869 views

Question details

Find each product's most recent update and return the associated update details.

Find the Latest Update for Each Product in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Open SQL View

In Microsoft Access, select Create > Query Design, then switch to SQL View.

2
Enter the query

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);

3
Run and review

Select Run and check the results. To include more product information, add the required PI field names to the SELECT list.

Use a Correlated Subquery to Find Each Product's Latest Update
Matching dates and missing updates: If multiple updates share the latest date, the query returns all of them. To select exactly one, use a unique update ID as a tie-breaker. The inner join excludes products without a matching update, and records with a null update_date do not match the maximum date.
Free Microsoft Office alternative

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.

Review and organize product update lists in spreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.