Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 21st, 2005, 01:06 AM
Friend of Wrox
Join Date: Apr 2005
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default Concatenating column values

Hi everyone!!

I have a table having 3 columns memberfname,membermname,memberlname. I want a query where I can get a column which will have the 3 fields concatenated into one with a single space in between.

I have used query using || operator to concatenate the fields but its not working.

SELECT memberfname||membermname||memberlname
        FROM tblmember;

Can any one help?
Old September 21st, 2005, 06:45 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Drop all three fields on the query, then create another field in the query that looks like this:

Name:([memberfname] & " " & [membermname] & " " & [memberlname])

Also, search Microsoft.com for their "Regular Expressions Reference."



Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenating values in a loop at a stretch!!!!!!! rakesh XSLT 5 July 23rd, 2008 11:21 AM
Modifying column values BabyToy BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 June 18th, 2007 10:15 PM
summing column values hydriswall PHP Databases 1 December 8th, 2006 04:54 AM
Datagrid column values krishnasamaga C# 2005 1 August 8th, 2006 06:54 AM
Datagrid column values pankaj_daga ASP.NET 1.0 and 1.1 Basics 4 November 17th, 2003 05:51 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.