I have a query in Access 2016 - I need to create a query to use as a lookup to another table. Below is the a prior example of my query and the after with the data I would like to generate. Is this possible?
Subscriber Type Subscriber Name Category1 Category2 Category3 Category4 Category5 Category6 Category7 Category8 Volume Level 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1235 Subscriber 2 Name b medium 1236 Subscriber 3 Name a c low 1237 Subscriber 4 Name b medium 1238 Subscriber 5 Name d high
Lookup Subscriber Type Subscriber Name Category2 Category3 Category4 Category5 Category6 Category7 Category8 Volume Level 1234-a 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-c 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-d 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-1 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-m 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-w 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-8m 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1234-pc 1234 Subscriber 1 Name a c d 1 m w 8m pc low 1235-b 1235 Subscriber 2 Name b medium 1236-a 1236 Subscriber 1 Name a c d 1 m w 8m pc low 1236-c 1236 Subscriber 3 Name a c low 1237-b 1237 Subscriber 4 Name b medium 1238-d 1237 Subscriber 5 Name d high