Page 1 of 1

Concatenation in Macro

PostPosted: Fri Oct 29, 2010 10:44 pm
by trc_pdx
I'd like to populate the value of a field on a form based on the concatenation of the values in two other fields. Thought I might be able to define a macro that concatenates the two other placeholders. If this is possible I haven't stumbled onto the right syntax. Any ideas? Thanks!

Re: Concatenation in Macro

PostPosted: Tue Nov 02, 2010 11:20 am
by eliaslynch
going off of memory, but isn't syntax like this?

Code: Select all
%[Assignee_ID].[Last_Name]%+ ', ' +%[Assignee_ID].[First_Name]%

doesn't that work? I see macros support full SQL queries now so can't imagine it won't work.