Results 1 to 4 of 4
  1. #1
    joshynaresh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    131

    Round number by adding 1 if DECIMALPLACE > 0 to value

    I wand to round my number by adding 1 if decimalplace is grater then 0. i.e. if my value is 2.01 then value should be 3, if value is 2 then value should be 2. If value has decimalplace then round it by adding 1. if there is no decimalplace then value should not be change.



    thank you

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If YourValue <> Int(YourValue) Then YourValue = Int(YourValue) +1

  3. #3
    joshynaresh is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    131
    Thank You RuralGuy for your reply.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are most welcome. I marked this thread as Solved for you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding sequental number with DMax.
    By MarcelWoltex in forum Queries
    Replies: 4
    Last Post: 10-09-2014, 04:43 AM
  2. Adding Auto Number field
    By jrmbach in forum Access
    Replies: 1
    Last Post: 08-12-2013, 04:30 PM
  3. Number Filed in Form auto round
    By blueraincoat in forum Forms
    Replies: 9
    Last Post: 04-11-2011, 06:18 AM
  4. Adding Part Number on demand that is not in table
    By patrickwelch in forum Programming
    Replies: 4
    Last Post: 03-21-2011, 07:53 PM
  5. Adding record with next sequential number
    By stanley721 in forum Forms
    Replies: 3
    Last Post: 02-28-2011, 01:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums