Forum Discussion
Solved
Creating a new record by combining multiple rows into a single record based on a unique identifier
Hello, I hope that you can help me with something that seems like it should be simple, but has me stumped! I am trying to create a new table from the table above. Each row is a vaccinatio...
It turned out that a crosstab will not produce the exact layout shown in your screenshot. However, a query with appropriate subqueries should do so. Note that this requires no more than 3 vaccinations in a series for one individual. More extended series would require more complicated logic.
This sample accdb and queries should show you how to prepare the display for the data in the layout illustrated.
Please do NOT do this. It's a bad plan.
If you want to DISPLAY the data in the format described for reporting purposes ONLY, you can do that, but please don't mess up the data in a table that way.
A Crosstab query should give you the results you want for reporting purposes in a display.
If you want to DISPLAY the data in the format described for reporting purposes ONLY, you can do that, but please don't mess up the data in a table that way.
A Crosstab query should give you the results you want for reporting purposes in a display.