Exp1:[First Name] & " "& [Last Name] Exp2:[Last Name] &", "&[Last Name] Exp3:[First Name]&[Last Name]
The first result would be Dawn Crosier The second result would be Crosier, Dawn The third result would be DawnCrosier If you want to create an update query and remove spaces, then look for help on Trim() and Instr() functions. Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Meeker Sent: Friday, December 15, 2006 12:08 PM To: [email protected] Subject: [ms_access] Queries Combining Multiple Fields 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 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.25/593 - Release Date: 12/19/2006 1:17 PM Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
