Latest Records to a query from the table

[Perfac]

I created a Gmail address “PerfacDibi@gmail.com” for this purpose only. You login at WWW.GMAIL.COM the password is “Hans1263”. There should only be two invitations to see or download my database from DropBox, the front end and back end. All Images are outside Access so this demo not much bigger than 250meg.


I have challenges on which I put in a lot of time but unfortunately no success yet.

In my database you may find queries q04VatRate01 and q04VatRate02. A friendly guy on the forum helped me to achieve the correct result in a query that return the latest record against a specific item, but the query is not updateable. I.e. if there are 10 inventory items which prices changed 10 times, there could be 100 records in the price table. To return the latest record against each item, means the resulting query should return 10 records of the 100 in the table. When new price records are added they will replace old ones in the query.

[Perfac]

I added a zipped file of the same database to the same email address that seems to be 612 bytes.

[Micron]

queries that use aggregate functions are not updatable. Without me downloading your db -
what might work is if you create a select query that uses a field from your existing query that isn't using such a function as a field you equal join on. I can't say for sure as I don't think I've ever joined a Totals query (what you have) to a select query. The idea being that the select query is updatable (not sure without trying myself).