Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004

    Unanswered: Table Query Problem

    Hi All. I am an amature Access user, and I seem to have run into a problem that me, or anyone else in my office can solve.

    I am running a "table-query". There are three tables I am joining, but I don't know if I'm doing something wrong. Everything does what it's suppose to, except when I run the query, the field names for my third underlying table show up in the new table, but the fields do not populate, even though they are populated in the original table.

    I hope I'm explaining myself okay, I don't know all the tech terms for this.

    Can someone give me some tips on how to fix this, or why it's happening?


  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    switch your query to SQL view and post the SQL

    currently using SS 2008R2

  3. #3
    Join Date
    Jun 2004
    Beaverton, OR
    It looks like either your relationships are wrong, or you have written your query wrong. Try running a query on only two of the three tables, and see what you get. Then you can work your way from there.

Posting Permissions

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