Array! (1 Viewer)

[IanT]

Hi

I have data in a table which I want to create a string from. There is a unique number ie SAuto.

Number SAuto
03/10/00/00001 23
1323213213313 23
4165468468465 23


So I want the string to be:

03/10/00/00001 - 1323213213313 - 4165468468465

Any ideas, I think a array would bdo thid but cannot work it out.

Cheers in advance

 

[Mr. B]

If you are talking about individual records, you will need to open a recordset and iterate through each record, reading and assigning each value to a string type variable. There really would be no need for an array unless you need to store all of the values and then at some other point in time, use the values to do some other type of concatenation with them.