Database for mailing labels

#1

Please advise me if a convention exists for how to set up the fields
for the street address part of a mailing labels database:
Should the street number and street name be in seperate fields or
should the street number and street name be in the same field.
Thanks very much.
-Dana

#2

danat (AT) co (DOT) lake.ca.us (Dana) wrote in message news:<50bbf815.0310021045.5bb86c90 (AT) posting (DOT) google.com>...

Quote:

Please advise me if a convention exists for how to set up the fields
for the street address part of a mailing labels database:
Should the street number and street name be in seperate fields or
should the street number and street name be in the same field.
Thanks very much.
-Dana

Hello Dana,

Traditionally, the street number and name are put into
the same field. But if you have something else in mind
for what you need, then put them into separate fields and
concatenate them when needed.

Example for a query - Address1: [StreetNumber] & " " & [StreetName]

Regards,

Ray

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Database for mailing labels

comp.database.ms-access comp.database.ms-access

Database for mailing labels - 10-02-2003 , 01:45 PM

Re: Database for mailing labels - 10-06-2003 , 11:02 AM