Forum Discussion
Creating a new record by combining multiple rows into a single record based on a unique identifier
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.
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.
Dear George, Thank you for your time and effort to assist me. It is very much appreciated. Your solution has worked very well.
- Congratulations on resolving the problem. Continued success with your project/
