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 Rhinorhino 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 Hansgen

  1. Hansgen

    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...
  2. Hansgen

    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...

Part and Inventory Search

Back
Top