I have two tables:
As you can see, ItemNumber, UserID, and TransactionDate are common in both tables. The other fields are the only things that differentiate the two tables.
The problem here is I want to construct a query and eventual report from that query that treats the results as one "virtual table". In other words, I want one column for ItemNumber instead of two seperate ones (since it is present in two seperate tables). The same for UserID. Right now I cannot do that.
Is there a way I can make the two tables "overlap" for purposes of this report? Or should I re-design the table into one big table and combine all fields? Any advice would be appreciated.