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 Rhinorhino 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: Stupot2k
  • Content: Threads
  • Order by date
  1. Stupot2k

    Summarizing Previous(fld) fields

    I am trying to calclate an MTBF figure for a number of reported incidents. I am using the Previous(fld)Function to calclate the time elapsed between subsequent records: ( {@actual_clear_datetime}- Previous ({@actual_reported_datetime})) * 24 When I try to summarize the field to work out an...
  2. Stupot2k

    Trouble converting text to a datetime

    I'm new to SQL so be gentle with me. We have a system called Microsoft Great Plains, it uses Business Alerts which as SQL Query based. In order to write effective queries I run them in query analyzer and then paste them into MGP. Our vendor has carried out some bespoke work for us which has...
  3. Stupot2k

    Convert Text to Date in a Query

    I'm new to SQL so be gentle with me. We have a system called Microsoft Great Plains, it uses Business Alerts which as SQL Query based. In order to write effective queries I run them in query analyzer and then paste them into MGP. Our vendor has carried out some bespoke work for us which has...
  4. Stupot2k

    Sub-Report Nightmare

    I am having a problem with Sub-reports. My main report searches for Customer Fault reports which are category 1 failures, I then have a number of sub-reports looking for Category 2,3,4 etc. If the main report does not return any records (legitimately) then the Sub-reports do not run. If I open...
  5. Stupot2k

    Missing Records

    I am having a problem when I carry out a query on an SQL database. Where I am looking to add a description from another table associated with a code, IE Personnel Number, and I want the Persons Name from another table. If the first record does not have the Personnel number on it, because the...
  6. Stupot2k

    VAL board anyone?

    Can anybody point me in the direction of any info regarding the VAL board IE "Voice Announcement over Lan board". I have heard that it exists but it seem illusive. Stu
  7. Stupot2k

    Auto-agent saluatation

    Does anybody know how to configure an automatic greeting for ACD agents. IE an announcement is played from an announcement board when and ACD agent answers a call. EG "Thank you for calling Acme Telecom, how can I help you" thus ensuring that all calls are answered in that way. I've...
  8. Stupot2k

    Previously enjoyed definity spares

    Does anybody know a good supplier of second user Definity spares.

Part and Inventory Search

Back
Top