Think I need to use IS NULL as OR but not working.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have a simple query that is not providing the results I need. Below shows part of the design view

table a table b table
*********** ********** *********
* pri-key inta * |------------* pri-key b_id* *pri-key c_id*-------->to c_i
* int b_id *----| * char bdesc* *char cdesc
* int c_id * *********** **********
**********
above shows the relations, and I am displaying inta, bdesc, cdesc from the query results. The problem is when
there is no int b_id entry for table a, I still want to list inta and cdesc for that item but there is no record returned
Thanks
 
Figured it out, just had to change the join properties on the relational link.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Relink a record? 1
Query not Returning Results 3
Display query results only if field is not null 3
Show 0 instead of Null 1
Returning multiple values within a single recordset 1
Blank Fields in NOT Null Query Criteria 5
Totals Won't Count Nulls 1
Ordering results, not as simple as it sounds 6

Back
Top