Concat 2 Fields

[#1]

Hi guy,

I have to fields i want to concatenate in a list box. My problem is that Field1 &' '&Field2 generates another empty value (known bug in QV11). However can someone give me an example how to solve this problem with the concat() function? I don't get the concationation function working based on the syntax. I tried for example concat(Field1, Field2).

Many thanks,

Harry

[prieper]

CONCAT can work only in aggregation, please check the Help-function.

The attached should do without blanks.

HTH Peter

[JonnyPoole]

If the fields were 'Region' and 'Year', this expression will eliminate the blank value for Year:

= if (  mid( Region & ';' & Year, FindOneOf(  Region & ';' & Year,';')) <> ';',Region & ';' & Year)

[#4]

Many thanks! I have tried the concat() and aggr() function and it worked.

However I'm searching a way to combine 2 variables into one variable.

But I think this is only possible in script. Please correct me if I'm wrong....

Many thanks,

Harry

[MarcoWedel]

Should also be possible with trigger/action.

[Anonymous]

@Harry_Lee Can you please post your script how u were able to use concat in an aggregated afunction. I can not use concat for some reasons