Solved

Access Table Divide into 2 or more tables equally

Posted on 2013-01-18
4
445 Views
Last Modified: 2013-01-18
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
Comment
Question by:Grizbear51
  • 2
4 Comments
 
LVL 26

Expert Comment

by:jerryb30
Comment Utility
Is there a unique identifier?
What is decision point for making more than 2 tables?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
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
 

Author Comment

by:Grizbear51
Comment Utility
wow you are one smart cookie - works like a charm thank you so much
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now