concatenate report fields in data report

[kristina99]

I have report in vb6.I have data environment and 2 commands.Commands2 has such fields: field1,field2,field3,field4,field5,field6.I'd like to concatenate field1,field2,field3 in one RptTextBox.For example:field1=02,field2=03,field3=971 and result should be RptTextBox=0203971 Thanks, Aleksandra

 

[dabest]

field1 & field2 & field3

 

[kristina99]

Thank you for your reply,but I did in Query (field1 & field2 & field3), I want to do that in report design .

 

[dabest]

In concatenating, we either use "&" or "+"
e.g.
field1 & field2
field1 + field2