How do I select 1/2 the records from my table

[Lizlomani]

Hi I have 2 million records in one of my tables. I want to select 1 million record or 1/2 of the records and create a new table from these records.

[ck9663]

Try the TOP clause.

Happy Coding!!!

~~ CK

[NeoPa]

CK has shown you a way to do this Liz. What I'd like to ask is why you want to. This may sound like a strange question, but I think I may know why, and it's not a good reason. Generally, storing similar data in multiple tables is not good design.

[Lizlomani]

CK has shown you a way to do this Liz. What I'd like to ask is why you want to. This may sound like a strange question, but I think I may know why, and it's not a good reason. Generally, storing similar data in multiple tables is not good design.

Apart from storing my data,I use access to do other analysis for my work. I need to divide the data in order to work in other software.

[NeoPa]

In that case I would suggest that a better way to approach this would be to view the data in the single table via the medium of a query then. I can't think of a scenario where the physical splitting of the data into separate tables is to be recommended.

Best of luck with your project anyway :)