As I said, I am not an expert so, vague human words is all I have but thank you for your input, I am a quick learner once pointed in the right direction. I am assuming (sometimes a bad thing to do) that this is the type of table details you infer. CREATE TABLE IF NOT EXISTS [Readings] ( [id] INTEGER PRIMARY KEY, [pollDate] datetime, [pollTime] datetime, [interval] INT, [import] REAL DEFAULT 0, [dateCreated] DATETIME, time_stamp VARCHAR); If not, could you elaborate further! One of the reasons why I cannot work out the answer is that I do not have the type of knowledge needed to describe the lack of knowledge I have to make it non vague. Cheers