[ms_access] Queries Combining Multiple Fields

[Tony Meeker]

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