M mjbryant New Member Joined Feb 17, 2003 Messages 27 Sep 28, 2006 #1 Does anyone know how to concatenate fields in an Access query? Thank you in advance!
giacomo Well-known Member Joined Feb 20, 2002 Messages 1,796 Sep 28, 2006 #2 try this: [field1] & [field2] hth, Giacomo
M mjbryant New Member Joined Feb 17, 2003 Messages 27 Sep 28, 2006 #3 Thank you! Well that sure is easy. One more thing, what if I want to insert a character (i.e. a comma) inbetween?
Thank you! Well that sure is easy. One more thing, what if I want to insert a character (i.e. a comma) inbetween?
giacomo Well-known Member Joined Feb 20, 2002 Messages 1,796 Sep 28, 2006 #4 [field1] & ", " & [field2]