(4) fields made into (1) field

[Guest]

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

 

[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

 

[Joseph Meehan]

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

You use a query to make it look like one field if you like. Except for
some really strange reason you should never combine them in a table.

Once combined, how would you get a list of people in Ohio for example.

 

[Guest]

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

Bob Levin

 

[Joseph Meehan]

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

Getting started in database, especially Access is a steep path. The
reason most of us know the real answer to your question is because we tried
doing the same kind of thing and later learned the error in our ways and
ended up re-doing a lot of work.

Good Luck

 

[Guest]

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
__________________________________________