blank query results convert to 0

[Vergy39]

WOW!!! I pretty much teared up when I saw the results of your queries. Thank you so much. This will work for me.

Also, there is no need for you to do this, but I was wondering what "unecessary criteria" I was using in the pending queries. I am trying to learn access, so it would be helpful to me, but don't worry about it if you are busy.

Thanks again, you are the best.
David V.

 

[Brianwarnock]

All of the matching of employee Ids that is what the join on employee ids does

(((TblIssues.EmployeeID)=15) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=15)) which actually is a small slice of

HAVING (((TblIssues.EmployeeID)=1) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=1)) OR (((TblIssues.EmployeeID)=2) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=2)) OR (((TblIssues.EmployeeID)=3) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=3)) OR (((TblIssues.EmployeeID)=4) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=4)) OR (((TblIssues.EmployeeID)=5) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=5)) OR (((TblIssues.EmployeeID)=6) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=6)) OR (((TblIssues.EmployeeID)=7) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=7)) OR (((TblIssues.EmployeeID)=8) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=8)) OR (((TblIssues.EmployeeID)=9) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=9)) OR (((TblIssues.EmployeeID)=10) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=10)) OR (((TblIssues.EmployeeID)=11) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=11)) OR (((TblIssues.EmployeeID)=12) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=12)) OR (((TblIssues.EmployeeID)=13) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=13)) OR (((TblIssues.EmployeeID)=14) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=14)) OR (((TblIssues.EmployeeID)=15) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=15)) OR (((TblIssues.EmployeeID)=16) AND ((TblIssues.IssueType)=1) AND ((Employees.EmployeeID)=16));

My clause is
HAVING (((TblIssues.IssueType)=1));

Note that if you have more employees you would have to alter your query, I would not.


Brian