Move duplicate values to new field?

Hi all, pretty new to Access.

I am trying to setup a query to show all the data on a single row by editing just 1 table. I know a workaround would be creating multiple tables (eg. Test comps 1, test comps 2, etc….) but I would like to remove those dupe part numbers and format into one. If you can point me to the right direction, it would be much appreciated. Anything will help. Thank you!

Here’s what I have : Main table with a subdatasheet that I can add records into : The subdatasheet referenced : What I’m trying to do.

submitted by /u/ChanounOzakaki
[link] [comments]