(4) fields made into (1) field

B

Bob Levin

I exported the "contacts" folder in from Outlook. There is a street field,
city field, state field, and zipcode field. How do I bring the data from each
of those fields in to one field? If not. could you suggest some other method.
Thanks so much.
Bob Levin
 
T

tina

i wouldn't do it. the data is already correctly normalized, so don't
de-normalize it. instead, you can concatenate the data in a query underlying
a form or report, or directly within a form or report, to *display* the
separate fields as a cohesive address. for example:

[StreetFieldName] & Chr(13) & Chr(10) & [CityFieldName] & ", " &
[StateFieldName] & " " & [ZipcodeFieldName]

hth
 
B

Bob Levin

Thanks much for the quick replys. That helps me a lot in my learnig process.

Bob Levin
 
T

Tom Wickerath

Hi Bob,

Spend some time reading up on the topic of database design. Here is a link
to get you started:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

Make sure to check out "Understanding Normalization", by Michael Hernandez.

Don't underestimate the importance of gaining a good understanding of
database design. Brew a good pot of tea or coffee and enjoy reading!


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top