Results 1 to 3 of 3
  1. 04-06-2019, 07:39 PM #1
    Unixaix
    Unixaix is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    2

    how to get a query from two tables?

    Can I union two table for query in access ?


    thanks!
    Reply With Quote Reply With Quote
  2. 04-06-2019, 08:42 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Yes. It's called a UNION query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 04-07-2019, 10:22 AM #3
    Unixaix
    Unixaix is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    2

    Thumbs up

    Quote Originally Posted by June7 View Post
    Yes. It's called a UNION query.
    I got it,Thanks!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Multiple Tables query with count/sum of third table based on query from first two tables.
    By TimH in forum Queries
    Replies: 4
    Last Post: 08-24-2016, 06:48 AM
  2. How to query what inputs (tables or queries) are used in a query?
    By sqlaccess in forum Access
    Replies: 2
    Last Post: 02-05-2014, 09:27 AM
  3. Using update query to populate tables based on a second query
    By Mattbro in forum Queries
    Replies: 3
    Last Post: 01-20-2014, 09:04 AM
  4. Query records from multiple tables and include records not mentioned on other tables
    By Ganymede in forum Queries
    Replies: 3
    Last Post: 01-05-2012, 12:04 PM
  5. Query -2 tables. Help.
    By zuli007 in forum Queries
    Replies: 1
    Last Post: 04-15-2010, 10:02 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums