Splitting a table

J

Jerry

In an Access query, is there a way to split a table into two tables
where the first table contains the first half of the original tables records
and
the second table contains the second half of the original tables records?

Thanks,

Jerry
 
M

[MVP] S.Clark

If all of the records have a number, date, or some other distinguishing
field, then you can use that as part of the criteria. Unless there is a
number available, you would have to manually determine what half was.

But there is no native way to say, "Gimme half".
 
J

John Vinson

In an Access query, is there a way to split a table into two tables
where the first table contains the first half of the original tables records
and
the second table contains the second half of the original tables records?
Click to expand...

Just to add to Steve's right-on comments: WHY would you ever want to
do this?

Having two tables of identical structure in your database is
essentially *never* a good idea!

John W. Vinson[MVP]
 
Top