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

    Cross Tab Table - or some alternative way of doing it - with suppresse

    Thanks! Works superbly!
  2. benshsms

    Cross Tab Table - or some alternative way of doing it - with suppresse

    Hi...not sure how I would do that, the number of occurences isn't a field in the database the table I'm querying just has a list of problem IDs which each have a major and a minor problem type. I'm sure there is an easy function I'm missing to count up the number of occurences of each type...
  3. benshsms

    Cross Tab Table - or some alternative way of doing it - with suppresse

    I have a database table with the following fields Problem ID Major Problem Type Minor Problem Type I need to output a report that shows something similar to... Major Problem Type Minor Problem Type NumberofOccurences...
  4. benshsms

    Time calculations

    thanks works a treat
  5. benshsms

    Time calculations

    Basic one really but struggling with it I have 2 time fields and want to calculate the difference between the two (with the result being a time). Datediff doesnt work becuase they are time variable (its part of a larger calc so I dont want to convert the variate to a datetime). I've tried just...
  6. benshsms

    Counting summaries

    a very basic crystal problem really but one of those need to knows... Have a database table Problem ID Severity E-122 1 E-23 1 E-212 2 And I need to present a report that shows. SEVERITY LEVEL NUMBER OF OCCURENCES 1 2 2...
  7. benshsms

    Passing a second parameter to LTRIM

    Thanks it works superbly...is there any similar code I could insert to delete to the RIGHT of the hypen?
  8. benshsms

    Passing a second parameter to LTRIM

    Essentially I want to write the SQL function LTRIM (JOBTITLE, '-') to remove anything before the hypen from the text field job title. however crystal's version of LTRIM wont allow me to pass the second parameter ('-'),or any other second parameter, into the function. Does anyone know of a...

Part and Inventory Search

Back
Top