Display a one-to-many relationship in one row
I could achieve your query in three steps. Assuming your table values are like the values listed below:




Step 1: In SQL View paste this query and save it as part1, This is for package_id transpose

TRANSFORM First([packing].package_id)
SELECT [packing].[product_id]
FROM packing
GROUP BY [packing].[product_id]
PIVOT [packing].package_id;

Step 2: In SQL View paste this query and save it as part2, This is for package_desc transpose

TRANSFORM First(packing.package_desc)
SELECT packing.product_id
FROM packing
GROUP BY packing.product_id
PIVOT packing.package_id;

Step 3: Join above two queries based on product_id to get your result