combine filds - Append Query in Microsoft Access


	Back to Append Query Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

combine filds

Bill D

3 years ago

I have a old database I made before I watched your videos. I made the database wrong. This database Is for my address Book. I have multiple fields for phone numbers for example phone 1, phone 2, phone 3, phone 4 etc. Now I am making a table just for phone numbers. Is there a way I can combine all the phone fields from the old table and put them into one field in the new table?

	Kevin Robertson @Reply 3 years ago
I would build a related table for phone numbers that relates back to your main table. Normalizing Data

	Scott Axton @Reply 3 years ago
In my PhoneT I have PhoneID, CustomerID, PhoneNumber, PhoneTypeID, IsPrimary. Related back to CustomerT via the CustomerID. The PhoneTypeID (Cell, Home, Work, etc.) I store in a Helper Table. See the Helper Data video.

	Bill D OP @Reply 3 years ago
Thanks for the help

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Append Query.

Next Unseen

New Feature: Comment Live View