Microsoft Access Move Multiple Rows In Table1 To A Single Row In Table2
0
votes
1
answer
467
views
I'm new to Microsoft Access so my terminolgy and understanding are limited, please bear with me. I am interfacing a piece of lab equipment via Serial/ASTM/ODBC to MS Access for Office 365 MSO 16.0.12.x.
The equipment and ASTM transmit different parameters per line via the same field names. So I end up with 23 different rows in Access and each row has a different parameter and result. I use Table1 as a queue. I need to move the captured data from multiple rows in Table1 to multiple columns in a single row in Table2. I've created a greatly simplifed version of the database to try to understand how to do this properly. Table1 is a simplified example of captured data. Table2 is a simulated example of what I am trying to achieve. Any help would be greatly appreciated.

Asked by NW94
(1 rep)
Oct 5, 2020, 05:14 PM
Last activity: Apr 16, 2025, 12:02 PM
Last activity: Apr 16, 2025, 12:02 PM