need help to divide tabel data in Access database

jagu147

Board Regular
Joined
Mar 19, 2014
Messages
71
hi,

i need help to divide access database

* i have 100 data in a table.
* i want selcet 10 each data from table and paste it in to another table.

regards,

jagu147
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Your going to need to give more information than that.

Is there some criteria that those certain records have? ie are the records have a field value that are equal to '10' ,are they text that have the word 'blue' in a field?
 
Upvote 0
the table format is below

date acctnumber name
9/17/2014 2000000000 abc
9/17/2014 2000000001 abc
9/17/2014 2000000002 abc
9/17/2014 2000000003 abc
.....
* 100 data will be there with diferent account number
* i want selcet 10 each data from that table and paste it in to another 10 different tables.

for eg. first 10 data to table A

Date Acctnumber Name
9/17/2014 2000000000 abc

next 10 data to table B

Date Acctnumber Name
9/17/2014 2000000011 abc

regards,
jagu147
 
Upvote 0
What are you actually trying to do. This is a very odd request for a database
 
Upvote 0
i want alllcoate the work to diferent user from 1st tabele.

i will receive 100 account detail daily.

i want allocate it to 10 users by pasting it in to there table. to work

and track the work they completed.

regards,
jagu147
 
Upvote 0
This is generally not a good design. What if you had a request to locate a specific record? Now you would have to search 100 different tables! What a nightmare that would be!

A better design would be to have a single table, and add a "User" field to it, and populate that. Then use queries to limit the data for each user to only see there own stuff.
 
Upvote 0
i dont have to search 100 tables.

*i have 1 main table in that 100 account detail
*i want alllcoate it to user by pasting it in to there table
like in 100 1st 10 account number should go alllcoated to one user
and next 10 to another user. total 10 users

using accces vba..

regards,
jagu147
 
Upvote 0
You will have 100 tables though after you distribute the data from the main table.
 
Upvote 0
In general it is bad idea and considered to bad design to have many different tables in your database of the same structure, and it is usually unnecessary.

Like I said, the better solution is to add a User field to your one table, and have that updated with your different User values, and then just use Queries to limit the view to a particular user.
 
Upvote 0
hi joe4,

could you please help me to create the databse based on the youre solution. i am new to the access database.

regards,
jagu147
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top