Tony, I can't figure out exactly where you are. Are you using the Access query tool? Or, are you writing your own SQL? The SQL for "displaying multiple columns at the same time" (combining?) would be SELECT MansLastName, WomansLastName, ContactsLastName FROM thetablename; I will do a little research to see how to trim the spaces from the right end of a field in SQL or the query tool. Of course if you use VBA you can do pretty much whatever you want. Dick
--- 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 >
