Concatenate recordset field?

E

EJO

Hello, folks, hope someone can provide some insight, and many thanks if
so...

In an A2k mdb using a SQL 7 on back end:

is it possible to concatenate a field in a recordset such that

var1 = rstMyTable!MyField & var2
and then
..cell(1,1).value = var1

The field is contained in a while loop to facilitate exporting to an
xls file and need to evaluate the value of the field, and in some cases
append information to it. I have noticed that trying to concatenate
does not change the exported value, that is, the exported information
completely ignores the appended information, and only exports MyField.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Serial # and Part # to create value for key field 3
concatenating problem 2
Pulling information from a recordset into a form 1
export vba not working 0
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
concatenating within a table field 1
Concatenating multiple records into one text field 4
Concatenate /w Chr(10) error 2

Top