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?

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."

HTH

mmcdonal