CONCATENATE REPORT FIELDS

[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

 

[petevick]

in a SQL statement that would create the record scource for the report, include something like

field1 + ' ' + field2 + ' ' + field3 AS MyFields

yes, those are single quote marks.

 

[aata]

yeah, as petevick said, why not retrieve the fields in a concatenated form thru the sql itself

 

[kristina99]

Thank you for your response , but I have forgotten to add that I'm looking for a solution in design time(Data report), not in run time.