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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by har1seldon
-
Best way to do an unmatched query
I will have to try this on a test access database but I will show an example of what I'm looking for in the ouput. 10 answer survey, this is survey #6 Table1=Entered by Joe (True=1, False=2, no entry=0) ID q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 6 2 1 2 1 1 1 2 0 1 1 Table2=Entered by...- har1seldon
- Post #11
- Forum: Microsoft SQL Server: Programming
-
Best way to do an unmatched query
I'm a bit new to database programming, that's my warning before I ask this followup question. How would you modify that query to display records that did not match (both had data, but they were different) as opposed to finding data that was simply not entered?- har1seldon
- Post #5
- Forum: Microsoft SQL Server: Programming
-
How do I compare table rows to check for errors?
How do I compare table rows to check for errors? Example of information tables. Table ABCD1 has values of 99 entries from 300 surveys Table ABCD2 has values of 99 entries from 300 surveys There are 300 survey forms making up records 1-300, each were entered by 2 separate data entry people...- har1seldon
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
