Hi,
I have a query that is made up of 5 tables.
The primary key in each table is my company ID field. The query results are a formatted text file which I export to a text tab delimited file. I then import this text file
into a Quark Xpress template. The problem is that it creates multiple instances of the company name. As a work around I've been using a access report and doing a hide duplicates on the Company field, this only half helps me because if the data can not fit on one page it prints the company name on the following page with the corresponding data. The query results I am getting is this:
Comp CoNo
@OVERSEASDATA:ABB Lummus Global 1,
@OVERSEASDATA:ABB Lummus Global 10,
@OVERSEASDATA:ABB Lummus Global 12,
@OVERSEASDATA:ABB Lummus Global 21,
@OVERSEASDATA:ABB Lummus Global 25,
@OVERSEASDATA:ABB Lummus Global 27,
@OVERSEASDATA:ABB Lummus Global 30,
@OVERSEASDATA:ABB Lummus Global 47,
@OVERSEASDATA:ABB Lummus Global 48,
@OVERSEASDATA:ABB Lummus Global 51,
@OVERSEASDATA:ABB Lummus Global 53,
@OVERSEASDATA:ABB Lummus Global 55,
@OVERSEASDATA:ABB Lummus Global 158,
The results I need are this:
Comp CoNo
@OVERSEASDATA:ABB Lummus Global 1,
10,12,21,25,27,30,47,48,51,53,55,158,
I would appreciate any suggestions, Thanks
in Advance!
I have a query that is made up of 5 tables.
The primary key in each table is my company ID field. The query results are a formatted text file which I export to a text tab delimited file. I then import this text file
into a Quark Xpress template. The problem is that it creates multiple instances of the company name. As a work around I've been using a access report and doing a hide duplicates on the Company field, this only half helps me because if the data can not fit on one page it prints the company name on the following page with the corresponding data. The query results I am getting is this:
Comp CoNo
@OVERSEASDATA:ABB Lummus Global 1,
@OVERSEASDATA:ABB Lummus Global 10,
@OVERSEASDATA:ABB Lummus Global 12,
@OVERSEASDATA:ABB Lummus Global 21,
@OVERSEASDATA:ABB Lummus Global 25,
@OVERSEASDATA:ABB Lummus Global 27,
@OVERSEASDATA:ABB Lummus Global 30,
@OVERSEASDATA:ABB Lummus Global 47,
@OVERSEASDATA:ABB Lummus Global 48,
@OVERSEASDATA:ABB Lummus Global 51,
@OVERSEASDATA:ABB Lummus Global 53,
@OVERSEASDATA:ABB Lummus Global 55,
@OVERSEASDATA:ABB Lummus Global 158,
The results I need are this:
Comp CoNo
@OVERSEASDATA:ABB Lummus Global 1,
10,12,21,25,27,30,47,48,51,53,55,158,
I would appreciate any suggestions, Thanks
in Advance!