• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 542
  • Last Modified:

Access Table Divide into 2 or more tables equally

I have an access holding table that contains any number of records any given day. Could be 20 could be 50 plus I never know.

Is there a way by access queries to divide it up evenly - say I have 50 records in the holding table and I want to send half to table 3 and half to table 4 ?
0
Stephen Roesner
Asked:
Stephen Roesner
  • 2
1 Solution
 
jerryb30Commented:
Is there a unique identifier?
What is decision point for making more than 2 tables?
0
 
Rey Obrero (Capricorn1)Commented:
create query like this

select top 50 percent * from tablex

select top 50 percent * from tablex
where [id] not in (select top 50 percent [id] from tablex as T)


try those queries and when satisfied, convert them to a MAKE table query
0
 
Rey Obrero (Capricorn1)Commented:
here are the make table queries


SELECT TOP 50 PERCENT T.* INTO Table3
FROM TableX As T


SELECT T.* INTO Table4
FROM decontact_tbl AS T
WHERE (((T.ID) Not In (SELECT TOP 50 PERCENT T2.ID
FROM decontact_tbl AS T2)));
0
 
Stephen RoesnerAnalysisAuthor Commented:
wow you are one smart cookie - works like a charm thank you so much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now