Results 1 to 3 of 3
  1. #1
    3PS is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    2

    make-table query


    Hi everyone- have a specific issue how to deal with a "make-table query", that makes a new table out of records from 2 other tables. I sort all records by the field, f.ex. projectID, and if I do not have any records for a specific projectID in one of the 2 tables, my new table, created by my "make-table query", will not contain calculated records from any of the 2 tables. Am I dealing with null-values or am I facing another problem?
    Regards 3PS Ole Roskilde Denmark.
    Last edited by 3PS; 06-28-2010 at 01:02 PM.

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Copy and change the the name of the Make table to new renamed SELECT Query.

    View in Data sheet. Can you see any records. If not your relationships may be incorrect.

  3. #3
    3PS is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    2

    make tables...

    Hi Rainlower- many thanks, I changed the relationships and found the the right way- problem solved regards 3PS

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

Similar Threads

  1. Field changes in Make table query
    By asherbear in forum Queries
    Replies: 9
    Last Post: 05-29-2010, 01:35 PM
  2. Replies: 2
    Last Post: 04-20-2010, 12:47 PM
  3. Make table query
    By Zahed in forum Queries
    Replies: 1
    Last Post: 11-06-2009, 05:44 AM
  4. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  5. Make a table query
    By Fiona in forum Access
    Replies: 4
    Last Post: 06-25-2009, 11:24 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