Splitting a table

  • Thread starter Thread starter Jerry
  • Start date Start date
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
 
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".
 
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]
 
Back
Top