Mailing labels: space between state & zip code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Typically you base your label report on a query. The query has a calculated
field:
CityStateZip:[City] & ", " & [State] & " " [Zipcode]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
Back
Top