Macro

N

N i M d A

hi everyone,

I have an access table with 5 fields and 50 records
like this,
acctnum name address zip city

can anyone give me a tip how to divide this table into 2 parts,
so instead of having one table with 50 records I need to have 2 table each
25 records,

I know I can copy the table & paste it then delete 25 records but I need to
write a macro

thanks
 
D

Douglas J. Steele

Why? It would likely be a misdesign to have two identical tables in your
database.
 

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

How to Overwrite Existing Records Using Import of TransferSpreadsh 1
How to count table records in a macro 1
VBA - retrieve data on last create named range from previous inserted named range 0
Need Macro to run cross tab query and export to access table 2
Conditional Loop in Macro 1
Copying cells from one data table and appending them to another using Microsoft Access 6
Calling a Sub from a Macro 2
How to split by the value of a field and copy to respectively exce 5

Top