rounding up

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I have a field that I want the user to enter as whole numbers only. for e.g
1day or 2 day but not 0.5 or 1.5. Tried the rounding up function but seems
to be very complicated...:)

I tried using :
If Right(Cstr(field),2)=".5" then msgbox...

How do I check for .1 to .9 in code?

Thanks in advance
Richard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Found a Bug or Error in Access 2002-2003 Round Function 3
Round Up a Decimal 6
Rounding numbers to 2 DP 4
How do I prevent a number from rounding in Access? 2
Stopping Fields from Rounding in Tables 2
Rounding 2
Round Function 3
Rounding up! 2

Back
Top