Formula Formatting (97 SR2)

Topic

New Reply

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?

Reply | Quote

Replies

have you tried datediff

Reply | Quote

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

“##.#” that does it!

Thanks for reading!

Reply | Quote

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

Reply | Quote

Thanks Douglas,

Dove into my monsterously huge Access Manual for that Can’t believe it..

I knew it was something ‘easy’…

Thanks again!

Reply | Quote