Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: How do I pull Data from 2 Queries?

    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!


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    SELECT columns FROM Table1
    SELECT columns FROM Table2 | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2008
    Worked Like a Champ!!! Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts