-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
need help to divide tabel data in Access database
- Thread starter jagu147
- Start date
TerryHogarth21
Board Regular
- Joined
- Mar 20, 2012
- Messages
- 245
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?
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
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
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,428
- Office Version
- 365
- Platform
- Windows
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.
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
*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
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,428
- Office Version
- 365
- Platform
- Windows
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.
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
Similar threads
- Question
