Solved

Access Table Divide into 2 or more tables equally

Posted on 2013-01-18
4
482 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 38793911
Is there a unique identifier?
What is decision point for making more than 2 tables?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38793923
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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38794021
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
ID: 38794829
wow you are one smart cookie - works like a charm thank you so much
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linking Master Child Fields 2 26
Microsoft Access 2016 Bug? 9 46
get and set file atrributes 5 11
Access vs Access runtime 6 15
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

749 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