I have a table that contains data fields that I need to translate into a new table or tables. Not all fields are used but for those that I copy into the new table they need to align with field positions from the original table.
Do I do a "Make Table" Query?
Originating Table:
FirstName MI LastName MemberNbr SeqNbr Addr1 Addr2 City State Zip DOB M1FName M1LName M1DOB M1SeqNbr etc...
New Table:
M1FName (MI Null Field) M1LName MemberNbr M1SeqNbr (Addr1 Null Field) (Addr2 Null Field) (City Null Field) (State Null Field) (Zip Null Field) M1DOB
How can I get originating fields into the correct alignment in the new (Target) table?
Guidance is much appreciated!!
Steve
Newark, DE
Bookmarks