Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding Problem (2002 (XP))

    I have a field on a report that displays the persons age Control Source is =(Date()-[dtmDOB])/365
    I have this set to 0 decimal places but it rounds up if over X.5
    I want it to round down always. Can I force this?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Rounding Problem (2002 (XP))

    Try =Fix((Date()-[dtmDOB])/365).

    Pat

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Problem (2002 (XP))

    Bingo!!!
    Thanks Pat

Posting Permissions

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