Results 1 to 2 of 2

Possibly a very simple question

  1. #1
    Ganymede is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    64

    Possibly a very simple question

    I used to be dangerous with access once upon a time. But I haven't had to make a database in quite some time.



    Say I have a form control with a value of x(a). And I have 19 tables with x and y values with one column for all x's and one column for all y's. x(a) appears at least once in each of those 19 tables. I want to run a query for the corresponding y value in each table. How would I go about doing that? Assume I know how to set query criteria based on form controls. I just can't figure out how to structure the query so the y values appear in a single column in my query.

    Years ago I probably would have known the answer but today I'm at a loss.

  2. #2
    Ganymede is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    64
    Never mind. I think I figured it out. This is a job for a union query.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-13-2013, 11:22 AM
  2. Replies: 3
    Last Post: 03-20-2012, 10:31 AM
  3. Newb question (but possibly complex)
    By MavisCruet in forum Database Design
    Replies: 3
    Last Post: 11-29-2011, 07:16 AM
  4. Simple VBA Question
    By koper in forum Access
    Replies: 1
    Last Post: 01-20-2011, 12:07 PM
  5. Simple question?
    By roads.zx in forum Access
    Replies: 0
    Last Post: 10-15-2009, 04:56 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
  •  
Tech Forums: Microsoft Office Forums