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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EONTECH

    Correlated Subquery problem

    Both of these suggestions work well. I will see which one is more effecient with the actual data. Thanks, everyone! Kevin (EONTECH) EasyOffice Network
  2. EONTECH

    Correlated Subquery problem

    Thanks for the suggestios, but they both still include CollectorIDs that DON'T have a status greater than 1. For example, using the data I provided in the original post, the result set should be: ItemID CollectorID 103 208 104 208 105 208 108...
  3. EONTECH

    Correlated Subquery problem

    Sample Data (assume table is called Chases): ItemID CollectorID CollectorStatus 101 205 1 102 205 2 103 208 2 104 208 3 105 208 2 106 209 1 107 209 2 108 210 2 I would...
  4. EONTECH

    #name? error on textbox with datasource from joined table

    I figured it out. I didn't create this--another developer did. I discovered that he had a bad habit of embedding SQL queries in several places throughout his code, especially in the various Form events. I had to modify four different instances of the SQL query. I am surprised that I didn't pick...
  5. EONTECH

    #name? error on textbox with datasource from joined table

    I have a form based on a view. The view has three tables--the data table and two lookup tables (Doctors, MedicalGroups, and StatusCodes). THe Doctors table has a groupID and StatusID field (as well as all its regular data fields). I want to have a textbox on the form that displays the Group Name...

Part and Inventory Search

Back
Top