Concatenating query results

  • Thread starter Thread starter johnh
  • Start date Start date
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
 
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]
 
You must log in or register to reply here.

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

Reusable statements in queries 2
Defining formats (i.e. bold, underline) for fields in forms/report 1
Finding null 4
Exclude query advise 4
Count field 4
Error when trying to use calc field from Query 8
Query Help! 2
Report showing ZLS as null 2

Back
Top