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
https://imgur.com/6eZKsLc : Main table with a subdatasheet that I can add records into
https://imgur.com/qFYksUm : The subdatasheet referenced
https://imgur.com/dbd7YV3 : What I’m trying to do.