Save yourself a step. If you already have data in your
existing table and want to move/copy it to another table
as described previously, just use a make-table query (or
two).

Create a query using your current table as the base and
select only the fields that you want in your new table
(employee number, vacation date, vacation note for
example). Change this query to a make-table query and give
your table a name. You can even create it in a new
database from here. Run the query and you will have your
new table the way you want it.

The only problem with this is that access defaults the
fields supplied in a make table query to 'text'. If one or
more of your new fields are not text, you would have to
modify the new table after you create it. Also re-running
the make-table query will wipe out any existing table of
the same name, including any changes made, so be careful.


-----Original Message-----
Having repeating groups of fields is not normalized. All
of your Vacation
fields belong in a related table
EmployeeNumber, VacationDate, VacationNote
Your Monday etc fields should also be broken out with a
more normalized
structure.

Once you have your new tables created, you can use append
queries to append
the records/values from your existing table.
--
Duane Hookom
MS Access MVP


"Westley" wrote in
message
...
I played around with the Table Analyzer Wizard. Is
there a way to not use
the wizard to split the database? I would like to have a
few different
tables.

Employees (EmployeeNumber, FirstName, LastName,
Address, City, State,
ZipCode, CellNumber, HomeNumber, BirthDate, HireDate,
TerminationDate,
Salary, ReferredBy, VacationDay1, VacationNote1,
VacationDay2,
VacationNote2, VacationDay3, VacationNote3, VacationDay4,
VacationNote4,
VacationDay5, VacationNote5, VacationDay6, VacationNote6,
vacationDay7,
VacationNote7, VacationDay8, VacationNote8, VacationDay9,
VacationNote9,
VacationDay10, VacationNote10, MondayAM, MondayPM,
TuesdayAM, TuesdayPM,
WednesdayAM, WednesdayPM, ThursdayAM, ThursdayPM,
FridayAM, FridayPM, Notes,
DateCreated, UserCreated, Date Modified, User Modified,
DateLeadsAcquired,
LeadsAcquiredAM, LeadsAcquiredPM, LeadNotes)

I would like the primary key to be EmployeeNumber on
different tables. How
would I do this? how would I create lookup tables? what
happens to my
original table?


.