Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rderkis
-
Filter out a group, if one particular field is identical
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? -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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 :-) -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
Compact and repair changed nothing. -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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... -
Filter out a group, if one particular field is identical
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...
