Results 1 to 3 of 3
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Query with relationed tables

    Hi,

    I have tried to explain my issue graphical beneath. (Small example from my large project.)

    I don't understand why my query QTest doesn't return ALL jobs when I have no criteria applied. I had expected all posts returned but some field values should be Empty in the query result.

    I have also attached my example in a file.




    Click image for larger version. 

Name:	Capture.PNG 
Views:	7 
Size:	36.8 KB 
ID:	26164
    Click image for larger version. 

Name:	Capture1.PNG 
Views:	7 
Size:	21.6 KB 
ID:	26166
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    It is correct, job 3 has no price key, therefore null.

  3. #3
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79
    I found it.

    I had to change Join Type to RIGHT JOIN. Then all records where returned. As expected.

    This is returned result now.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	6 
Size:	4.6 KB 
ID:	26168

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. Replies: 2
    Last Post: 02-05-2014, 09:27 AM
  3. Replies: 3
    Last Post: 01-20-2014, 09:04 AM
  4. Query or Tables
    By finsmith in forum Database Design
    Replies: 1
    Last Post: 12-28-2012, 08:09 AM
  5. Replies: 3
    Last Post: 01-05-2012, 12:04 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