I have a form containing two text boxes (1Average, Average1) that the first one is containing formula typed in form and the result of that is in decimal data type. I want to copy the result in [1Average] to the [Average1] text box for this i used the following VBA code:
Code:
Private Sub Text151_AfterUpdate()
[Average1] = Me.[1Average]
End Sub
But this code copy the value with full rounding the decimal part and doesn't copy the real decimal number for this i need to edit this code to copy the decimal value without any change and rounding.
I am new to this forum and Access 2000. When creating a table I want to use a field to record hours worked to the tenth of an hour. When I enter 6.7 and tab to the next field the hours record as 7. I am using field size as integer, decimal as 1 and format as general number. I have tried numerous other combinations, but whatever decimal I enter rounds to show no decimal in the table. I will use this field in calculations. I suspect the solution is simple, but I am not having any luck. I'd appreciate some help. Gary4
I am using an inventory software program called ERP. I am trying to have at least 8 decimal places show in all my reports/tables/etc. I have set decimal places to 8 and 8 are showing up in some the reports BUT after the 4th decimal place, the other 4 decimals default to 0 (i.e. I put .19214, but only .19210000 shows up). In other tables only 4 decimal places are showing up (no 0 or anything after the 4th decimal place. I would greatly appreciate any help!!!
I have a table set up with a numeric field with 2 decimal places. When this table runs through a couple queries and comes out in a report - somehow the number is rounded. Where would the rounding occur - how can I stop it from happening?
Is there anyway in a query or a form to set the amount of decimal places on a number or change it to currency. In one query im dividing a price by a mileage and I get a really long string of number and I need to make it just be two decimals.
I have search the forum and cannot find an answer, can anyone please help. I have a few field in my table that have number and I would like to be able to enter decimal place numbers like 8.25.
I have set:
Field Size = 'Long Integer' Format = 'General Number' Decimal Places = '2'
When I go to enter a number it rounds to the whole so when I enter 8.25 it inputs 8.
Any ideas? I need the decimal to show in the query and the form and it isn't showing in any of those. I have set the query to 2 decimal places and form to 2 decimal places.
I want to but numbers with 2 decimal places in a field. I have the data type set to number in the desired field - yet when I copied and pasted the data over, all the numbers that had 2 decimal places lost them. The only number visible was the whole number. How can I make the numbers reatain their 2 decimal places?
Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for numbers. if some one have idea?
Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for numbers. if some one have idea?
Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for numbers. if some one have idea?
I have values (using a make-table query) in an Currency field like £123.45.
Using an update query, I want to make these values become £123. What function, or otherwise, can I use to get this?
I have used a combination of the Round and CInt functions to do this but all I get is £123.00 not £123. I know I can change the DecimalPlaces table property to 0 to get what I want, but I am running code to do all this, hence I need an update query that will resolve the issue if possible.
Is there a way to make some of the entry fields in my form auto add the decimal so that when users do data entry they do not have to enter the decimal point? I can do it in excel, but I haven't figured out how to do in Access form.
I want to be able to just enter 456755 and it format correctly, when the actual number is 4567.55.
I would like the users to enter values of day 2.5 however it always rounds up to 3 i have checked the propeties of the field in the table and i have set it to 2 decimal places. I have also checked the property of the field on the form and done the same. There must be something i am missing.
I have a query with a calculated field Qty=([tons]*[%AC]) that I need to round to three decimal places before making next calculation of total dollars ([unit price]* [Qty]). I know I can display the three decimal places by using format - Standard and decimal places 3 but it still calculates with all the decimal places of the original calcuated quantity and when the report prints showing the extended dollar amount is not what it appears it should be Qty may display18.019 but is actually calculating on 18.018737864077. I have searched this forum and access help but have not found anything to correct this problem. Any suggestions.
I am making a query in which one of the fields I want to display is a Calculated field. It is just two other fields divided. I want to display this calculated field with 0 decimal places, but when I view the properties, there is no decimal places box. There is everything else like the description, format, input mask and so on. Any ideas?
Hi, I have a column in my table that I have set as a number. I have also set decimal places to 2 but when I type in 0.75 and move to the next entry, it changes the 0.75 to a 1! How do I make it not do that? Many thanks
I'm having a realllllly frustrating problem. I'm trying to enter the number 101.1 in a field, but whenever I enter it and hit tab to move to the next field it just truncates the number to 101. I've changed the number type, the number of decimal places, ect - everything! But it still changes my 101.1 to 101 after I move to the next field.
In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:
[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.
[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.
**Every charge amount is different, and every codes length is different; so there is no consistency in this field.
I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.
