Mailing labels: space between state & zip code

[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

 

[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

 

[Guest]

Terry - thank you - this worked!
Susan

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
.

 

[PC Datasheet]

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