Append New Values only

[lordrom]

HI,

I currently get sent rows and rows of data, but am only ever interested in the last row of data for an event that I receive.

I want to create a table that only shows me the last rows for these events, so i created a make table query that retreives the 'LAST' values. The problem with this is that it gets deleted evry time I run it, and since i changed the structure and added some other columns with data, I don't want to have to recreate this additional stuff each time.

So I want an append query that only appends new events to the table each time I run it. I'm guessing that there is a way to do this?

I'm good in Excel and VBA, and have only ever really used Access to store single tables. Now i need to use it properly so am getting to grips with the basics and hope someone can help point me in the right direction on this.

Thanks

 

[lordrom]

i created a primary key on 3 fields to determine uniqueness, and set the append query to return only unique values only

it gives an error about not being able to insert all the records, but if i click add anyway it does append the new rows only.

so i have it working, but i'm not sure it is the most efficient way. if anyone has the 'correct' solution i'd be grateful