Ok, This is probably simple, but I've looked in 2 of my books, and all over the net, and I cant seem to get it to work. Heres what I am trying to do:
I have 2 tables that are links to xls files. They are my inventory files (for a car dealership. They have Stock#, year, make, model, price, inv cost, ect)
Table 1 = All Stock Units
Table 2 = All recent Trade ins (this is where they end up before being manually entered as a stock unit. Sometimes in this file for 3 days or longer before being removed from this file, and added to the stock unit file).
I want to have a Query be able to show *BOTH* Tables. So if I have 180 Cars in Table 1, and 30 in Table 2, I want my Query to show a *master list* of 210 Cars.
Thanks guys. I've only been using access for about a month or so now. It has helped me out SOOOOOOO much, and I have sooooooo much more to learn!