Managing records within access please 1

[outhere]

Hey, I have a table in access of 10000 records. What Id like to do is take the first 2000 records, put then into a new table, while removing those 2000 from the original 10000 record table. I beleive I will be needing to use an SQL phrase but am blind to the whole thing. Please would someone help me. Ive found ways around this problem but it long and the room for error is large.

Thanks
Steve

 

[Dreamboat]

Do these 10,000 records have a specific criteria? If so, use the criteria to create a query.

When you know the query selects the exact 10,000 records, save it. Open in design view, and hit Query-make table, then run the query. This creates your new table. Then, hit Query-delete query and run the query. This deletes those records from your original table.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[outhere]

Thanks for the help techgirl,
what I cant seem to figure out is how to select say 2000 records and not all of them.
Im sure if i keep playing with it ill get it but thanks for the right path...

Steve

 

[Databaseguy]

Use the TOP predicate of the SQL Select Statement. You can choose it in query dedign view under query properties. Make sure and test it first, as ot won't always return the reords you'er "expecting".

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy