Help SQL with Access 2007

ilottl, Nov 11, 11:02am
OK so my SQL statement is WHERE (((tbl_StatusTypes.StatusType)-
="Allocated") AND ((tbl_SalesReps.SalesRepName)=-
[Forms]![frm_SelectRep]![Enter-
Rep]) AND ((tbl_Calls.CallDate) Is Null))

Problem is that if tbl_calls at the end is empty there is not data returned. However, thats the point I want to show all contacts that have not been called. Any ideas on what the SQL should be??

joopa, Nov 11, 2:34pm
Paste the FROM part too.
Looks like you have INNER JOIN to tbl_Calls which will return parent rows only when matching row from tbl_Calls is found.

Replacing Inner Join (or plain JOIN) with LEFT OUTER JOIN should do the trick.


jancemord, Nov 11, 6:26pm
talk to mrtoken

Share this thread

Buy me a coffee :)Buy me a coffee :)