User Profile

Collapse

Profile Sidebar

Collapse
memfbi
memfbi
Last Activity: May 8 '20, 01:05 PM
Joined: Apr 30 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • memfbi
    replied to Issue with fixed decimal places
    in Access
    Hello
    Thought I had this working, but not quite. It appears that I need to round up to get the correct answer.... I need the below to return .113, but is returning .112
    MGCP10 = 5.00 VOLP00 = 225
    Code:
    UPDATE PGAS000
       LEFT JOIN
       PGASC02
    ON PGAS000.MGC100 = PGASC02.GPRD02
SET    PGAS000.[MGC1$0] = ((Round([MGCP10]/100*[VOLP00]/100,3)))
    See more | Go to post
    Last edited by NeoPa; May 5 '20, 02:55 AM. Reason: Added mandatory [CODE] tags.

      Leave a comment:

    • memfbi
      started a topic Issue with fixed decimal places
      in Access

      Issue with fixed decimal places

      Hello
      I have an update qry to a table with a field defined as Number/Double/Fixed/3 decimal places.
      When I view table the field displays as .001, but when I click on the field it displays as.00057. I need to use this field in later calculations to be .001, but in the later calculations it is using .00057.
      How can I keep this field at .001?

      Thank you
      See more | Go to post
      No activity results to display
      Show More
      Working...