I had given considerable thought to the problem of the phone field. I started to work on the distint idea but realized that, if a group had all blank (CID)phone fields, they would be suspious calls. Why does this have to be so hard :-) Is that what seperates us hacks from you proffesionals?
Works like a charm! That filters it down to 73 records :-)
I just can't belive you did it! The problem now is that the sql is so complex, how can I figure it out?:-)
Like you said Gregory Saibert password was not empty, so how does this sql account for it?
I was hoping to filter out all the...
I guess I should explain what I am trying to do.
We have a job call recording that plays, when a person calls from home (CallerIDPhone number check), or enters their unique password. All this is looked up from a different database.
All calls are logged to a database. With the JobDispachDate...
Here is the brief cut down database. The password is 777
http://lft.buckeye-express.com/download.cfm/968
If you don't get the same mixed results, I will commit myself :-)
This is one of the abnormalities I get with your sql.
Like I said 99 records down from 232 records show, so its much closer. But why does GREGORY SEIBERT show? I then tried this sql
WHERE Members.ssn = Members1.ssn and Members1.passwordnum > "9" ))
With this sql, only members groups whith...
Strange, I changed the "members1.passwordnum is not null" to "members1.passwordnum is null" and got mostly just groups with blank passwordnum fields in them, but there were few groups, where the entire group had a valid passwordnum in them!? I am going to compact and repair the database now. I...
You are so cool! Your sql mostly works, it took the view from 238 records down to 99. There are still a few groups where the entire group has the same ssn numbers and blank passwords. Which of course makes no sense to me! Why would it catch most but not all? Perhaps those passwords fields...
Thank you once again! But I think you are way beyond me!
I boiled what I have down, to make it simpler. This works but includes the unwanted groups.
SELECT Members.JobDispatchDate, Members.SSN, Members.FirstName, Members.LastName, Members.passwordnum
FROM Members
WHERE Members.JobDispatchDate...
I really appreate you attempt and time!
I have struggled with this so long. I wish it was that easy!
I have not tried your example yet. But I don't see how it would work on a group.
I think it would just filer out all the records with no password, including Bill Hay's 1 record. :-(
My...
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...
