Mailing labels: space between state & zip code

S

Susan Bero

I am using Access 2003. I imported a name & address table from Excel and used
the mailing label wizard to make a mailing label report to print the mailing
labels, but I cannot get a space between the state abbreviation and the zip
code. Can anyone help?
Thanks
 
T

Terry

Susan,

Don't know how your data is structured or how your report
is laid out. You could try =[state]&" "&[zip] in a
control. If this doesn't help please post back with more
detail.

Terry
 
S

Susan Bero

Terry - thank you - this worked!
Susan

Terry said:
Susan,

Don't know how your data is structured or how your report
is laid out. You could try =[state]&" "&[zip] in a
control. If this doesn't help please post back with more
detail.

Terry

-----Original Message-----
I am using Access 2003. I imported a name & address table from Excel and used
the mailing label wizard to make a mailing label report to print the mailing
labels, but I cannot get a space between the state abbreviation and the zip
code. Can anyone help?
Thanks
.
Click to expand...
Click to expand...
 
Top