MS Access PIVOT with User Defined Field
- by user2535359
Any of you good souls please help!!
I need to query the source table shown in the below. (NULL are blank fields)
UNUM, Ticket, Overflow
1 , 135 , NULL
1 , 136 ,NULL
1, 137, NULL
1, 138, NULL
1, NULL, 2b
2, 135, NULL
2, 136, NULL
2, 137, NULL
3, 135, NULL
3, 136, NULL
3, 137,NULL
3, 138, NULL
3, 139, NULL
3, 140, NULL
3, NULL, 66a
4,…
