Help

[tmartin]

I have two tables: Transactions and Employee's. There is a 1 to many relationship between tables. The employeeID is a foreign key in Transactions table.
I want to extract a list of employees who have never had any transactions. If I use the Groupby and select Count I will get a list of employees and the number of transactions. For those employee's who have no transactions their name never shows up in the list. I tried setting the criteria to >=0 , =0 and this did not work.



I have put together a form to allow the employer to delete accounts that no transactions. For those employee's who no longer work there but have transactions I have implemented an four states login security configuration: owner, Manager, employee, and inactive. For those no longer employee are then just put to inactive.

Any ideas?

[pbaldy]

Try the unmatched query wizard.

[tmartin]

That did what I needed. for some reason just overlooked that capability. Thanks agin

[pbaldy]

No problem. By the way, in the future, a more descriptive thread title will help users searching for answers to their questions.