mailing label

[cmichaud]

I am working on a mailing label and have a simple problem.

=Trim([StreetAddress] & " " & [CityID] & ", " & [State] & " " &
[ZipCode])

thats the address line. Well instead of displaying the CityID (whihc
is a number) i want it to display the city name.

tblCity
CityID
City

I cant figure out how to change the lookup for the label.

Would really appreciate some help.

C

 

[Joshua A. Booker]

=Trim([StreetAddress] & " " & [City] & ", " & [State] & " " & [ZipCode])

Make sure the city field is in the reports recordsource.

HTH,
Josh

 

[cmichaud]

perfect. thanks.