create n tables, with 20 o less records from one table with macros

V

vlado666

Hi, sorry for my english.

I have a table with n records, the point is create tables with 20 or less
records until I done with the n records. i want to do a macro but I dont
know how create the instruction on sql/macro/forms/etc.

Please help me!

thank you,

best regards,
 
T

tina

so you have a single table, and you want to create multiple identical tables
and distribute the single table's records among them, correct? my second
question is, why? multiple identical tables usually implies that the data is
de-normalized. if you'll explain to us what you're trying to accomplish,
probably we can help you achieve your goal while following relational design
principles.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setvalue from a Table Row 2
parsing and importing a text file with records through a VBA macro 1
Exclude enter query records from linear record navigation 4
Append Copy of Table 9
Copying cells from one data table and appending them to another using Microsoft Access 6
Access 2007 - Overflow + error 2950 when running a macro 10
FrontEnds with "filtered" access to records in backend tables 2
Using Excel as Interface for big SQL Server Tables?! 1

Top