Hello-

I'm fairly new at using Microsoft Access and I'm having trouble getting a couple of things to work in my database.

The first is that I have yet to find a way to get an append query to add only new records and not all the records. As an example, this query filters a list of property owners for duplicates and then appends to a table where they are assigned autonumer IDs. The problem is that I'm constantly entering...