I have a query based on two tables, one of which allows multiple values for the primary key. However, I want this query to show only one of each duplicate record. I know I can do this by setting the Totals to first, last, etc. However, if I do this, Access no longer allows me to update the field values in the query. Anyone have any suggestions?