Macro

  • Thread starter Thread starter N i M d A
  • Start date Start date
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
 
Why? It would likely be a misdesign to have two identical tables in your
database.
 
Back
Top