Display Blank Fields

[Xenix]

I have two tables, One Company details and another which is Business Sector, there can be multiple Business sectors for a company so I use this method and link with company name. I want to generate a report with only the companies that have no business sector filled in?? Can anyone help me??
when I have tried to create a query it only shows the records that have the Business sector filled in?

Help help would be greatly appreciated

Mike

 

[helenpostle]

change the criteria of the business sector field to is null, then it should only show the records with no value in business sector

 

[Xenix]

Thank you, If I do that is shows no records, I think this is due to the table Business sector, it only has the company name in it if there is a Business sector

any other advice?

 

[Pat Hartman]

You also need to change the join type to Left.

Select C.CompanyId, C.CompanyName
From tblCompany As C Left Join tblBusinessSector As B On C.CompanyId = B.CompanyId
Where B.BusinessSector Is Null;

 

[Xenix]

Thank you Pat

)
that worked fine

Regards
Mike