Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Formatting (97 SR2)

    I'm sure it's something so simple...

    I have a formula on my report that subtracts two dates, The field looks like this in design mode:

    =trim(" Average processing time was " & format([datecomplete]-[datestarted],"nn.n") & " Days."

    I'm having issues with the portion in bold. I want it to return only one decimal. In some cases, it's extending the decimal by hundered-thousandths, too much detail for reporting purposes.. I'm sure it's simple.. any ideas?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (97 SR2)

    have you tried datediff

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (97 SR2)

    That's not a valid format string. I think you mean #0.0 instead of nn.n.

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (97 SR2)

    I need the number of days.. this formula is doing what I want, it's just returning too many decimal points.

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> "##.#" that does it!

    Thanks for reading! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (97 SR2)

    Thanks Douglas,

    Dove into my monsterously huge Access Manual for that Can't believe it.. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    I knew it was something 'easy'...

    Thanks again!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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