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

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

    Convert MM to DD:HH:MM

    I have got a time which displays in Mins (1590) but would like it to display Days, Hrs and Mins (1 Day, 2 hrs, 30 Mins). How do I change it? Thanks
  2. T1na

    Pulling out one record between dates

    Having problems getting the results that I need can anyone help? I have got a School attendance report which runs between dates. Between the dates I want the School history pulling out for the School that has been selected. It seems to work for all students apart from the ones that have been...
  3. T1na

    Calculate date and hours between start and end

    In Crystal 11 I would like to calculate the date and hours between a start{datetimefield} and end {datetimefield}. I know about the datediff but need a little help with the time.
  4. T1na

    Taking spaces out of field name

    We have a surname field that has two names in it e.g. Bob Jones the space is causing problems in validation. How do I take the space out and replace the space with a – so will receive the following result Bob-Jones.
  5. T1na

    Greater than last record put on system Pls Help!

    Having problems with SQL, what I want is sql alert that pulls off students that are year 6 and new to our system. Is there any function in SQL that I can pickup students that are greater than the late student.id that is in the system So far I have got: SELECT STUDENT.FORENAME...
    • T1na
    • Thread
    • Replies: 3
    • Forum: MySQL
  6. T1na

    Linking a string

    I am using the if then else function but the string that I have put in is to long and I receive the following warning: There are too many characters in this string. I have tried to split the string but don’t seem to be having any luck. Please help

Part and Inventory Search

Back
Top