Results 1 to 2 of 2
  1. #1
    intern is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    6

    Two Tables, One Query


    I have two similar tables, one outlining areas of work and the other outlining trips to that area. Table One shows the continuum of work, whereas Table Two shows fixed points in that continuum. I'd like to have one query which draws all information about this area of work. The pertinent column headings are the same (Area of Work; Organization; Started; Ended; Contact), and I'd like to be able to read the continuum and the fixed points in time in the same query, organized vertically.

    Is this possible, without having them side by side?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I'm thinking you are making this more difficult than need be. Perhaps you are stuck with these questions because your data is not Normalized.

    I suggest you try creating a query to answer your questions. Use the Query Builder. If making a JOIN and creating a simple SELECT query that provides some good results does not happen within a few minutes, revisit your data structure and Normalize.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-05-2014, 09:27 AM
  2. Replies: 3
    Last Post: 01-20-2014, 09:04 AM
  3. Replies: 3
    Last Post: 01-05-2012, 12:04 PM
  4. Trying this query from 2-Tables
    By djclntn in forum Queries
    Replies: 6
    Last Post: 11-13-2011, 09:25 AM
  5. Query on 3 tables
    By aveit in forum Access
    Replies: 0
    Last Post: 04-26-2011, 12:01 PM

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