Updatable query to identify most recent dates

[Clint Marshall]

I am trying to identify the most recent year that property taxes have been
paid for each of our properties and how much was paid in that year in a way
that can be combined with other data in an query that is updatable.

Currently, I use a total line and the "MAX" selector to find the highest
year number for each property (using just the fields "year" and "property").
I then use the output of this query to run against the original table to
identify the actual taxes for that year. This process works fine for
finding the most recent taxes paid for each property, but the query is not
updateable.
The problem is that I now have to combine the year, and the associated tax
amount, into a query that feeds a form that has to be updatable. The data
from the tax query doesn't have to be updated, and logically couldn't be,
but other pieces of data unrelated to the taxes have to be updatable.

How do I make this work?

Thanks in advance!

-Clint Marshall

 

[Van T. Dinh]

See if the following article helps:

http://www.mvps.org/access/queries/qry0020.htm

 

[Clint Marshall]

This is a good step, but when I combine this query with another query, the
combined query is still not updatable.
Any way around this?

-Clint

 

[Van T. Dinh]

I certainly can't say without details of the relevant Tables, what you try
to get out of the Queries and the SQL Strings of the 2 Queries.

Perhaps, you should post the above details and see if others can come up
with possible solutions.