Round Up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Text Box that I have do the following

=(Now()-[OB_Start_Date])/30

I use it for billing. If a client goes one day into a month the rate is for
the whole month How can I set it so it will round up the next whole number?

Keith
 
I have a Text Box that I have do the following

=(Now()-[OB_Start_Date])/30

I use it for billing. If a client goes one day into a month the rate is for
the whole month How can I set it so it will round up the next whole number?

Keith
Click to expand...

Answered in m.p.a.forms. Please, if you want to post to multiple
newsgroups, use the "Advanced" button on the bottom of the message
composer (since I see you're using the website) to Crosspost rather
than multiposting. This lets the volunteers see that a reply has
already been posted.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top