Getting data in columns instead of rows of linked table

[Anil Bagga]

I have a Form and a SubForm which have 2 tables associated with them.



When I build a query linking the 2 tables, the data in the main table comes in multiple rows, each row having the different data of the linked or child table. I want the child table data in separate columns instead of rows and only one row of the parent table for each record

In the enclosed DB I have 2 tables and one query linking the 2 tables.

I searched the internet and forum but could not find anything similar which could address this requirement

Is this feasible?

[CJ_London]

you have three tables in your db, not two you refer to, so no idea which is the 'main' table and which is the 'child' table

Also no idea which fields you are referring to.

Would help if you provided the table names you mean, the field names you mean and an example of what you want as an output from one of the records from your 'main' table - use excel if necessary

So best I can suggest is use a crosstab query

[mike60smart]

Can you give us an example of what you want to see displayed for the current "qryFabricTapeConstruction?"

[June7]

Already answered at https://www.access-programmers.co.uk...t-rows.324901/

[Gicu]

Hi Anil,
Depending on your needs crosstab query (limited to the current record loaded in the main form as if you try to build one based on the whole tables you cant because you exceed the number of allowable fields) or a field concatenating the codes - see the SimpleCSV() function:
http://www.accessmvp.com/thedbguy/co...itle=simplecsv
Cheers,

[Anil Bagga]

you have three tables in your db, not two you refer to, so no idea which is the 'main' table and which is the 'child' table

Also no idea which fields you are referring to.

Would help if you provided the table names you mean, the field names you mean and an example of what you want as an output from one of the records from your 'main' table - use excel if necessary

So best I can suggest is use a crosstab query

Thank you for your response and I am sorry for the incomplete information. I have enclosed an Excel sheet for the template of the Query output. The brief explanation of the relationships of the 3 tables is as under:

1. tblFabricCodeMaster_New This is the primary table which has the fabric codes. Each fabric can be made with a maximum of 6 types of tapes
2. tblFabricTapeCons_New - This table has the Bill of Material of tapes used to make the fabric. it has the Tape codes id and its location (Wp1, Wp2..). These 6 locations for the tapes are shown in the Excel file
3. tblTapeCodeMaster - this has the Tape Internal codes which we want in the query under the 6 locations of the tapes

I am not familiar with the crosstab queries and will appreciate if you help me out with this query

[June7]

Why don't you respond to the answer provided in your other thread?

[CJ_London]

because you are cross posting and an answer has been provided in the other thread plus a further example in this thread, I don't see the point of spending further time on this question

[Anil Bagga]

because you are cross posting and an answer has been provided in the other thread plus a further example in this thread, I don't see the point of spending further time on this question

Thank you. Have seen the other post

[Anil Bagga]

Hi Anil,
Depending on your needs crosstab query (limited to the current record loaded in the main form as if you try to build one based on the whole tables you cant because you exceed the number of allowable fields) or a field concatenating the codes - see the SimpleCSV() function:
http://www.accessmvp.com/thedbguy/co...itle=simplecsv
Cheers,

Thank you Vlad. Beyond my comprehension unfortunately.