Welcome! Log In Create A New Profile

Advanced

Using calculated field in queries to merge fields

Posted by Joel 
Forum List Message List New Topic
Joel
Using calculated field in queries to merge fields
February 14, 2009 05:50PM
Hi -

I'm sure this is a simple question - in a calcualated field in a query, how do you merge 2 of more fields together? For example: "His name is " + Contact.FirstName + " " + Contact.Lastname. (This doesn't work - but it's what I'm trying to accomplish)
Reply Quote
DerekT
Re: Using calculated field in queries to merge fields
February 14, 2009 06:01PM
Joel

Use ' instead of "

'His name is ' + Contact.FirstName + ' ' + Contact.Lastname

Regards

DerekT
Reply Quote
Joel
Re: Using calculated field in queries to merge fields
February 14, 2009 06:22PM
Many thanks Derek!
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: