Results 1 to 3 of 3
  1. #1
    Steelersfan26 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    5

    query from multiple tables

    I have a database that consists of about 30 tables. These tables have forms associated with them. In the forms I have a combo box, for one of the fields, where the user needs to select which department they are from.
    I need to create a query/report using multiple tables based on the date it was completed and the section who completed it.
    On my main form I have a combo box for the user to select which section's report they would like to run. That part works, it filters out the correct data, but it puts all the data in a single row.
    Click image for larger version. 

Name:	Screen Shot 2017-04-18 at 1.43.16 PM.jpg 
Views:	8 
Size:	85.3 KB 
ID:	28299

    Click image for larger version. 

Name:	Screen Shot 2017-04-18 at 1.51.43 PM.jpg 
Views:	8 
Size:	132.7 KB 
ID:	28301



    I am trying to pull the same data from each table, i.e. section, name, date completed, next due, and notes...how do I make it so that those are the only headings and the data is underneath, rather than it displaying a separate heading from each table?

    Thanks!

  2. #2
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Sounds like you need a Union Query possibly but that design of your tables and fields should be considered for rework. Does the IDs link all the tables so they are all 1 to 1 relationships?

  3. #3
    Steelersfan26 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    5
    Ok, I'll try out the union query.
    The relationships could be the other issue. None of those tables have a relationship. Not really sure how the relationships work.

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

Similar Threads

  1. Replies: 4
    Last Post: 08-24-2016, 06:48 AM
  2. Multiple Tables, One Query
    By MFS in forum Queries
    Replies: 4
    Last Post: 06-16-2014, 03:14 PM
  3. Replies: 1
    Last Post: 04-12-2013, 03:03 PM
  4. Replies: 3
    Last Post: 01-05-2012, 12:04 PM
  5. Query from multiple tables
    By ambidextor in forum Queries
    Replies: 1
    Last Post: 02-25-2010, 08:01 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