Concatenating query results

J

johnh

Hello all,

I have to come up with a really weird report layout. it takes values
from two tables(which I have a query for) and then I need to put them
into a LINE format, field1/field2/(next record)field1/field2/(next
record)field1/field2, etc...

How can I pull this off and have the output go into a report format?

Thanks muchly
John
 
J

John Vinson

Hello all,

I have to come up with a really weird report layout. it takes values
from two tables(which I have a query for) and then I need to put them
into a LINE format, field1/field2/(next record)field1/field2/(next
record)field1/field2, etc...

How can I pull this off and have the output go into a report format?

Thanks muchly
John
Click to expand...

You can probably adapt the code at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]
 
Top