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 Chriss Miller 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: *

  • Users: drewby1
  • Content: Threads
  • Order by date
  1. drewby1

    AAC_EVENT

    Hi Can anyone post me a few example lines of idle events from the AAC_EVENT table please (obviously omitting any personal/company info). I'm writing some code to pull thru idle time from the AAC_EVENT table and link with the CALLDETAIL table but the idle events aren't logging at the moment...
  2. drewby1

    LOGON_USER not forwarding in IIS

    Hi Any server variables relating to user info (Auth_User, Remote_User, Unmapped_Remote_User, Logon_User) are not being picked up in IIS. This problem occurs on my laptop as well as remote (LAN) web servers. I'm running IE6 (IE6.0.2800.1106.xpsp2.030422-1633 with Q837009, Q832894, 3282...
  3. drewby1

    Percentages in split/count query

    Hi I'm trying to create a query which gives an output something like... ScoreDist Tot %age 1. >= 85% 303 49.11 2. 75% - 85% 187 30.31 3. 50% - 75% 110 17.83 4. < 50% 17 2.75 Total assessments 617 I've got the Score distribution and Total columns...
  4. drewby1

    JOIN problem

    hi i have 2 tables, Q and QMS common field's are QMS.AgentCupid and Q.Cupid i want to list all records in QMS and also the OverallScore field in Q if there is one. fields to view QMS.Name , Q.OverallScore sample output would look something similar to... Name OverallScore J B 75% A...
  5. drewby1

    UPDATE if exists, else INSERT new record

    Hi All I have 2 tables (TABLEA and TABLEB). One is populated with data and has a unique field TABLEA.QMref. The other will hold extra data but will also have the same unique field TABLEB.QMref. I want to insert a new record in TABLEB from a form frmDATA with several checkboxes (and a QMref...

Part and Inventory Search

Back
Top