Converting 22 records in a single one (1 Viewer)

[hbtousa]

Hi everyone . Please I need help with this
I have a db with 22 records: (A123,B456,C789...Z999) I want to be able to read each record and extract from each one the same data fields and make a big single record out of the reading:A23+B56+C89...Z99 The reason of doing is I want to be able to show on a form the data extracted from the multiple reading.
I tried a crosstable, but gave no much room to work with. I think if I use 22 different queries it wont look professional and hard to maintain. I've being considering better a loop with maybe multiple if conditions but I dont know how to apply it. Something like
newrecord = ""
for x=1 to 22
read record x
newrecord = newrecord + record x
next


Thanks

 

[KenHigg]

Look at post number 7 here:

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

ken

 

[hbtousa]

I cannot open it. Thanks

 

[KenHigg]

Here's a 97 version...

ken