Results 1 to 6 of 6
  1. #1
    faca is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    52

    Combine query from 2 databases

    Hello!

    I have two same databases (car mechanic). First one has car services from 2018 and second one from 2019.

    How can i join together query from one and second database ?

    This query is used to make report for past services...

    When i click on button i need to enter VIN or License plate number and than i get info about car and all past services.



    I want to use only second database (with 2019 services) so when i'll check past services i want all from 2018 also to be displayed



    Any advice?


    Thanks

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Link the appropriate tables from one db into the other. From my perspective, I wonder why you would have two db. Why not have only one with dates applicable to service performed.

  3. #3
    faca is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    52
    Quote Originally Posted by alansidman View Post
    Link the appropriate tables from one db into the other. From my perspective, I wonder why you would have two db. Why not have only one with dates applicable to service performed.
    Beacuse there is too much entries for 2018 (for me) so i rather split them by years...

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Give us a guess of how many records are too many. I agree with Alan this would normally be 1 database with a field, such as ReportingYear or similar, with values for the appropriate year/date.
    You could always archive by year if you really do have many more records than I suspect.

    You could create a query in 1 database and link the appropriate table(s) in the second database and include both tables in your query.
    Good luck with your project.

  5. #5
    late1day is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    3
    Thank you for your help. I will give it a shot.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    In what way do you want to include both datasets in one query - JOIN or UNION? A JOIN doesn't really make sense to me
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 11-15-2015, 04:43 PM
  2. Combine two databases with lots of tables with same name
    By FoolzRailer in forum Import/Export Data
    Replies: 11
    Last Post: 11-02-2015, 09:28 AM
  3. linked databases query
    By vicsaccess in forum Queries
    Replies: 5
    Last Post: 10-09-2015, 03:01 PM
  4. Union Query Across Databases
    By jo15765 in forum Queries
    Replies: 1
    Last Post: 04-18-2014, 09:10 AM
  5. Query several databases to UPDATE one
    By Kelrizzo in forum Queries
    Replies: 4
    Last Post: 10-27-2011, 10:26 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
  •  
Other Forums: Microsoft Office Forums