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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Returns Different Results When Loaded Into Recordset
Thanks Golom. The query is intended to return one record for each assoc_id and not a single record. As it turns out, I found the issue shortly before I received your reponse, although I had been working on it for a couple of days. I was getting different records when running the SQL in the...- Hansgen
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL Returns Different Results When Loaded Into Recordset
What I am trying to do: I have a header table and a detail table. Both tables have a boolean column. I want to update the boolean in the header to be false if all of the matching detail records are false, or true if any of the detail records are true. I have tried many approaches with similar...- Hansgen
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
