combine two fields

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

Guest

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
 
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]
 
Back
Top