when concantinating fields together use the trim function i.e.
=Trim([mansLastName] & ", "&[womansLastName] &", " &
[contactsLastName])--- In [email protected], "Tony Meeker" <[EMAIL PROTECTED]> wrote: > > > In a query, how does one combine several fields? For example, I have > "Man's last name" > "Woman's last name" > "Contact's last name" > > Is it possible to get rid of any blank spaces? > > Thanks, > > Tony >
