combine two fields

T

Ty

I have two fields "City" and "Province" I somehow want to have them on my
report beside each other with a comma between and to "automatically truncate
any extra space - for example:

Toronto, Ontario
Montreal, Quebec
Vancouver, British Columbia

Thanks !

Ty
 
R

Rick Brandt

Ty said:
I have two fields "City" and "Province" I somehow want to have them
on my report beside each other with a comma between and to
"automatically truncate any extra space - for example:

Toronto, Ontario
Montreal, Quebec
Vancouver, British Columbia

Thanks !

Ty
Click to expand...

Use a ControlSource of...

=[City] & ", " & [Province]
 
Top