concat 2 fields

[Iamwilliamlo]

Hi all,

i had a straight table which i tried to use concat function to merge first two columns. 

i put =Concat([FltDate WeekYear]&''&[FltDate WeekSun]) in the expression but comes out with error. i want to display 202032. apprec your help.

[tresB · Accepted solution]

Perhaps you don't need concat(), but just:

[FltDate WeekYear]&''&[FltDate WeekSun]

, unless you want to aggregate on values. 

[lironbaram · Accepted solution]

hi 
you don't need concat function

you can use 

[FltDate WeekYear]&''&[FltDate WeekSun]

[Iamwilliamlo]

thanks for help. Its work!