Finde forskeld

Se forespørgselsguiden "find relaterede poster", den finder de poater der er ens i bege tabeller.

Og guiden "Find dubletter" finder de poster der er ens i tabellerne.

Ja men skal jeg så oprette en tabell for hver uge? det lyder jo ikke særligt smart, da jeg får ny dataer hver uge.
Og jeg skal ikke finde dem der er ens.
Jeg skal finde dem der er nye, og dem der er forsvundet, og få dem presenteret.

"Jeg modtager hver uge nogle tabeller med data."
derfor antog jeg, at de nye data består af en tabel.

Du kan jo også prøve guiden "Find ikke relaterede poster", som giver dig de poster der er i den ene tabel men ikke i den anden.

no there isnt any easy method for doing this. But a little more information might help!

You say "nogle tabeller". Do you mean a number of tables or one table for each week?

Is there a primary key which can be used to find already existing records and missing records?
Dou you also want to see records which have changed and if so, how many fields need to be compared?

and what ever else might be of help

To Clarify a bit.
I receive 1 table per week, but with hundreds of Records, Each record does not have an Identifier, but the collected fields in the record makes each row Unique, so I can use those fields as a Primary Key.
It has 2 fields that identifies the Row uniqly.
[PE], [Interface]
I can use those fields as a Primary key.
However, I saw a problem with that, If next week I get a new bunch of records, and import those to the same table, I will have conflicts, with duplicated keys, since a lot of the records will be same as previous week.

Hope this clarifies a bit.
The only solution I could se was to Use Excel and do a VB code that checks every entry and runs it through all the records, but I figured there must be an easier way.

If all fields in a record make up the primary key then all that you can do is INSERT records which do not already exist.

Try importing all records into a TEMP table which has the same layout as the original table. Then make an APPEND query whcih takes the records from the TEMp and INSERTs them into the original. If ALL fields make up the primary key then only records whcih do not already exist will get APPENDed to the table.

can you use any of these answers?

Oh Sorry, I have not had a chance to try it yet.
I work shifts, and Have not been in the office for over a week.
I will try it Wednesday or Thursday.

OK

I have not had time to check this, but no use you guys waiting for my response.
Thank you guys, you both get 60p for the effort.

thanks, drop a comment if you still need help when you get around to lookin at it