Lin Set the variables
vFullName = (FirstNameColumn & LastNameColumn) vCityProv = (City + ',' & Province) Make sure to put the parens around them. Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Sunday, February 17, 2008 7:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: odd behavior in Reports?? or not Ok, closed down and restarted and all worked correctly again. Hmmm... How do I do this? I'm trying to concatenate 2 text fields into one (FirstName & LastName) and also to add a comma between another (City, Province) Thanks, Lin On Sun, 17 Feb 2008 16:38:49 -0800, "Lin MacDonald" <[EMAIL PROTECTED]> said: I am having what I think is odd behavior in the Report Builder but maybe, I am just not going about it right: Add/Edit Variables brings up the Expression Builder screen. I can delete Variables but I can't change them or add new ones. When I hit Change or Add, nothing happens. If I try to add a Variable to my Report, the Variable I just tried to create shows up in that list, but still not in the Add/Edit list, so I can't change it when it doesn't work. I'm trying to concatenate 2 text fields into one (FirstName & LastName) and also to add a comma between another (City, Province) So, is this odd behavior or should I be doing something else? Lin
