Query to show clients not attached to an item

[griffo]

Hi there

I'm wondering if it is possible to come up with a query that will tell me which of my clients haven't had an item entered against them.

My (simplified) structure is:
tblClient
ClientID (PK, Text)
ClientName (Text)

tblItem
ItemID (PK, Text)
ItemName (Text)

tblClientItem
ClientItemID (PK, Autonumber)
ClientID (Text)
ItemID (Text)

I can create a query which forms the basis of a report to show me which clients are attached to an item, but I need to know which ones are NOT attached to the item.

Is this possible, and if so, can someone give me a starting point please.....

Ideally, my report will be grouped by Item Name and have a list of the clients with no record against that Item.

If you need any clarification, please let me know!

Thanks
Griffo

[Joe4]

Under Queries, click on the New icon and select the "Find Unmatched Query Wizard" option. This Wizard should walk you through how to create an Unmatched Query.