Format Query Output

[govmule]

Hello,

This is my first post in this forum, so please forgive me if I'm in the wrong place.

Environment - Microsoft Access 2003 connected to Informix 7.3 database via ODBC driver

Problem - I need a query that will produce output suitable for loading into another application. Each record will have two lines and a blank line before the next record.

The first line will be all columns from a table with a | (Bar) delimiter separating the columns and a 'Y' inserted at the end. On the next line all columns from a different table (joined to the first table with an equal join) with a | (Bar) delimiter separating the columns and a 'Y' inserted at the end.

The output would look sort of like this:

[table1]?????|???????|???????|???????|??????|?????|Y|
[table2]?????|????|?????|Y|

[table1]?????|???????|???????|???????|??????|?????|Y|
[table2]?????|????|?????|Y|

etc, etc

Can anyone help me? If I'm not in the right place I appologize and can someone point me in the right direction.

Thanks in advance,

Jack

 

[PHV]

Have you tried to play with a Report ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886