I have a table with the following data:
Decal User 1 User 2 1 John 2 Alex 3 Jane Eric 4 Pope Pete 5 Robert
And I wanted to create a query that displays:
Decal User 1 John 2 Alex 3 Jane 4 Pope 5 Robert 3 Eric 4 Pete
I tried to create queries, one for User1 and another for User2, and then join them with a third query. However I could not remove from the query for User2 the ones that had blank User2's. Any help is greatly appreciated! The decal is not the primary key, it is hidden.