M
Mota
Hello;
I have a table having 2 fieldsID,dName.Although DID is a unique field,the
table's PK and a Long accending number,but its numbers are not followingly.I
mean the 8th record may have DID=8 but for the 9th record DID=10 and for the
10th one DID=17.There is a report based on this table that prints products
label.Each label contains a DID and a dName.Each label width is about 1/3 of
an A4 paper width.So it wastes the papers.I want to bind report to a query
that can put each 3 records of this table as 1 record containing 2*3
fields.Then i can put that 3 fields in 1 grid of report,so print 3 label in
one grid,instead of 1 label in 1 grid.
Example:
What i have in the table,named MainTBL: (Data are just for test)
--------------
DID dName
1 ABC
2 DEF
3 GHI
5 JKL
6 MNO
9 PQR
What I need (The query must return):
--------------------------------------------
DID dName DID2 dName2 DID3 dName3
1 ABC 2 DEF 3 GHI
5 JKL 6 MNO 9 PQR
Is that possible?If yes,what would be the SQL statement of this query?
Thank you so much for your help.
I have a table having 2 fieldsID,dName.Although DID is a unique field,the
table's PK and a Long accending number,but its numbers are not followingly.I
mean the 8th record may have DID=8 but for the 9th record DID=10 and for the
10th one DID=17.There is a report based on this table that prints products
label.Each label contains a DID and a dName.Each label width is about 1/3 of
an A4 paper width.So it wastes the papers.I want to bind report to a query
that can put each 3 records of this table as 1 record containing 2*3
fields.Then i can put that 3 fields in 1 grid of report,so print 3 label in
one grid,instead of 1 label in 1 grid.
Example:
What i have in the table,named MainTBL: (Data are just for test)
--------------
DID dName
1 ABC
2 DEF
3 GHI
5 JKL
6 MNO
9 PQR
What I need (The query must return):
--------------------------------------------
DID dName DID2 dName2 DID3 dName3
1 ABC 2 DEF 3 GHI
5 JKL 6 MNO 9 PQR
Is that possible?If yes,what would be the SQL statement of this query?
Thank you so much for your help.