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

On Sat, 27 Nov 2004 15:39:02 -0800, "KAnoe"
<(E-Mail Removed)> wrote:

>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

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