rderkis
Military
- Oct 17, 2005
- 11
How do I filter out a group, if one particular field is identical, in all that of group? (Using Access 2002)
My query runs, but when all the group's PasswordNum is empty I DON'T want it to show.
Quary runs and looks like this.
PasswordNum is a number field.
SELECT Members.JobDispatchDate, Members.SSN, Members.FirstName, Members.LastName,Members.PasswordUsed
FROM Members
WHERE (((Members.JobDispatchDate) In (SELECT [JobDispatchDate] FROM [Members] As Tmp
GROUP BY [JobDispatchDate],[SSN] HAVING Count(*)>1 And [SSN] = [Members].[SSN] )))
ORDER BY Members.JobDispatchDate, Members.SSN;
Output Looks Like This
JobDispatchDate SSN FirstName LastName PasswordUsed
4_10 234 ANTHONY ESPESITO
4_10 234 ANTHONY ESPESITO
4_10 456 ANTHONY SMALLWOOD 1234
4_10 456 ANTHONY SMALLWOOD 1234
I don't want ANTHONY ESPESITO group to show because his Password is empty.
I have spent weeks on this problem. Sent and received countless emails. Still no one can solve it, and many have tried!
THANK YOU! For your time.
My query runs, but when all the group's PasswordNum is empty I DON'T want it to show.
Quary runs and looks like this.
PasswordNum is a number field.
SELECT Members.JobDispatchDate, Members.SSN, Members.FirstName, Members.LastName,Members.PasswordUsed
FROM Members
WHERE (((Members.JobDispatchDate) In (SELECT [JobDispatchDate] FROM [Members] As Tmp
GROUP BY [JobDispatchDate],[SSN] HAVING Count(*)>1 And [SSN] = [Members].[SSN] )))
ORDER BY Members.JobDispatchDate, Members.SSN;
Output Looks Like This
JobDispatchDate SSN FirstName LastName PasswordUsed
4_10 234 ANTHONY ESPESITO
4_10 234 ANTHONY ESPESITO
4_10 456 ANTHONY SMALLWOOD 1234
4_10 456 ANTHONY SMALLWOOD 1234
I don't want ANTHONY ESPESITO group to show because his Password is empty.
I have spent weeks on this problem. Sent and received countless emails. Still no one can solve it, and many have tried!
THANK YOU! For your time.