[AccessD] Query Help

Try this:

SELECT Customers.CustID
FROM Customers INNER JOIN Policies ON Customres.CustId = Policies.CustID
GROUP BY Customers.CustID
HAVING (((Count(Policies.CustID))=1));
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030609/78769fc1/attachment-0001.html>