Access 97 or 2K - TechRepublic
General discussion
November 8, 2000 at 04:08 AM
parier

Access 97 or 2K

by parier . Updated 25 years, 7 months ago

In a report I would like to take the following fields from a form:
Name
Address
City
State
Zip

. . . and add them all to ONE field and keep the standard formatting of a address, for example
Name
Address
City, State Zip

I tried =[Name] & [address] & [city] & “, ” & [State] & ” ” & [Zip]
but there must be a “carraige return before the city. Is there?

Thanks in advance!
Eric

This discussion is locked

All Comments