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 gkittelson 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. maggiev

    Time Conversion

    The above sample was a typo it should had said 145008. I tried both formulas but I am getting errors. This is my first time using this so it is probably user error. The first solution from Naith is black when the report runs. The second solution it gives me a air message that a number...
  2. maggiev

    Change Number field to Time field

    Thanks Ngolem! it worked like a charm. :) Maggiev
  3. maggiev

    Change Number field to Time field Question Clarified

    maggiev (MIS) May 8, 2002 To clarify my problem the time field in the DB shows as a a Number. For example 7:59:11 shows in the DB as 75,911.00 When I turn this number field w/o decimals it shows as 75911. If the time is 13:06 it shows in the field as 130,621.00 When I turn this to a...
  4. maggiev

    Change Number field to Time field

    To clarify my problem the time field in the DB shows as a a Number. For example 7:59:11 shows in the DB as 75,911.00 When I turn this number field w/o decimals it shows as 75911. If the time is 13:06 it shows in the field as 130,621.00 When I turn this to a number w/o decimals is 130621...
  5. maggiev

    Change Number field to Time field

    I am currently working in a CR Report. The time field shows as a number field such as 125044. I want this field to show as 12:50. I do not need the seconds. I am a new user and not very good with formulas. I appreciate a little help. Thanks, Maggie

Part and Inventory Search

Back
Top