Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Iowa
    Posts
    13

    Question Unanswered: Number formatting?

    I'm adding times for a time sheet project...

    In the report, it is adding correctly, but once it gets to a total of over 24:00, it start back at zero???

    What number format must i use to add times, but have large values as totals?

    Thanks in advance

    BEN

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    you should use integer addition to get the times. Right now you adding number as hours in a day which can never be more than 24.

  3. #3
    Join Date
    Jun 2004
    Location
    Iowa
    Posts
    13

    ok, but..

    now where would i do such an activity?

    the only othre choices are general number, fixed, and standard. all these types give my wacky decimal numbers never reaching higher than 1?

    thanks again

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by captainmcdoogs2
    now where would i do such an activity?

    the only othre choices are general number, fixed, and standard. all these types give my wacky decimal numbers never reaching higher than 1?

    thanks again
    You can set it up at Table level. Select data type as Number. Then below in the properties select from the FieldSize area, Integer.

    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •