Thanks, I'm trying with WHERE but I'm just not getting the gist of it yet.

I want it to look at the Date to be unique and only to take through to the new table records only with dates not currently in the new table.

The only problem is we get this data sent into us and the date comes through into the database in a plain text format e.g. '20121219' as it just comes as part of a long string of info I split up.

The column I then pass it into is Reading_Date.