Thank you all for your responses.

Mark & Karol, thanks also for the explanation. Your suggestions have worked for me and now when I query the table the results look correct.

Regarding the number of rows, there will be around 240,000 - 250,000

Cheers

Vaughan