Modules & VBA :: Round To 2 Decimal Places
Apr 1, 2014
Problem: I want to "round" (to 2 decimal places) numbers 1-5 down and 6-9 up. For example:
1.915 = 1.91
1.916 = 1.92
I know this is completely screwy but I have to match numbers up to a purchasing system that seems to be doing just that.
I've researched rounding in Access a lot and I understand Bankers rounding (that won't work), I understand Int() and Fix() both don't do what I need. I've something about rounding half down (which is what I think I need) or Floor which I don't quite understand.
View Replies
ADVERTISEMENT
Jun 2, 2005
Hi there,
I am not sure the best way to do this,
I have a field with values that look like: 1.69553366385509 or 0.0061705541157596
I want these values to look like: 1.6955 or 0.0062 (4 decimal places [rounded up if possible])
Thanks for your help with this
Sue
View 5 Replies
View Related
Feb 25, 2014
I have about ten append queries to group various financial data to one main table.
I have used the round function (iff (Round(Nz([FIN_data]),2)) in the queries to round the original data into 2 decimal places but there is still one or two lines exceeding 2 decimal places.
What is the better approach to have only 2 decimal places for all append data?
View 4 Replies
View Related
Apr 11, 2014
I have a subform that displays doubles in a textbox as fixed with 4 decimal places as default. I have been trying to change the number of decimal places based on the value in a textbox on the main form. I have tried this:
Code:
Forms![Main Form]![Holder_subform].Form![Final PCT].[DecimalPlaces] = CByte(Forms![Main Form].Numdecs)
where [Final PCT] is the textbox on the subform containing the decimal number and Numdecs is the textbox on the main form containing the number of decimals I want to use. I want to implement this Form_Current sub.
View 2 Replies
View Related
Jan 6, 2006
Hi, I have this query and I would like to have the avg display with only 2 decimal points. This is my SQL and I think I have to use this code but I'm not sure.
FORMAT(CountOfStudent Attended,'.00')
If I ad this after the SELECT statement my query will not work. What am I doing wrong?
Thanks!
~D
This works
SELECT [Attendance for Avg].CRN, Avg([Attendance for Avg].[CountOfStudent Attended])
AS [AvgOfCountOfStudent Attended]
FROM [Attendance for Avg]
GROUP BY [Attendance for Avg].CRN;
View 3 Replies
View Related
Jan 10, 2007
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!!!
THANK YOU!!!!!!
LL
View 14 Replies
View Related
Apr 12, 2005
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.
Thank you very much!
Adam
View 1 Replies
View Related
Jan 26, 2006
Hi all,
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?
Elliot
View 3 Replies
View Related
Aug 8, 2006
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.
View 2 Replies
View Related
Nov 24, 2005
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.
Thanks for lookin gand your help.
View 5 Replies
View Related
Dec 13, 2004
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.
View 6 Replies
View Related
Oct 14, 2006
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?
View 2 Replies
View Related
Jan 17, 2007
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
View 1 Replies
View Related
Mar 20, 2015
On one of my Access forms, a specific textbox rounds a value down if the user enters the decimal. The table field bound to it, is a long integer as to not accept decimal values.
For example = user entered .5 rounds to 0
user entered 10.5 round to 10
I would like this to behave in the opposite manner and always round up, but how??? Since users are estimating their hours for specific tasks, I would prefer any decimal value to round to the next integer. I have tried many adjustments to get this working to no avail. I did come across something about key press for decimal and to disallow user to even enter a decimal in this textbox. I would be fine with that solution as well, but could not implement as seen.
View 7 Replies
View Related
Aug 5, 2005
Hi,
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.
Help muchly appreciated.
View 8 Replies
View Related
Sep 19, 2005
I have this code:
MaxCPC = Bid2 / 7
But I want MaxCPC to be stored to 2 decimal places. If I click in the field, quite often I get something like 2.3256 but I only want 2.32.
How?
View 3 Replies
View Related
Jan 10, 2007
Hi everyone,
I have a field in a table holding numbers with no more than 2 decimal places eg. 96.87
Field Size = 'Double'
Decimal Places = 'Auto'
The data appears fine in Access and when exported to Excel.
However, when I merge the data into a Word document the numbers have loads of decimal places, so 96.87 becomes 96.87777777777777777777
What can I do!!??
Thanks
View 1 Replies
View Related
Mar 23, 2006
I have a database that requires a particular field to have varying decimal places (1 or 2) based on a value in another field. This data will be used in calculations and exported to Excel for graphing so the text format is not an option. Is there a way to set this up in the table or have it format properly in a report?
View 1 Replies
View Related
May 27, 2005
I would like to force a field to be 2 decimal places in the SQL view of a query as I am creating a UNION.
If is there anyway of doing this? I have tried CONVERT() & FORMAT() but I can't seem to get this to work.
Any help would be greatfully received.
Kind Regards
Carly
View 1 Replies
View Related
Feb 24, 2005
I have the following code to calculate output per hour. It works but how can I limit the result to two decimal places.
Private Sub Hours_AfterUpdate()
Me.lbloutputph.Caption = Me.Qty / Me.Hours
End Sub
Thanks
View 2 Replies
View Related
Dec 12, 2005
I'm having a problem exporting my table as text and having three fields reporting only 2 decimal places instead of the 4 that i need.
I'm using Access 200 on Windows XP Pro.
I searched the forums and the only thing i could find was to create a querry and using ColumnName: str([dblNumber]) somehow. I don't really unerstand what they were trying to do except that somehow this converts the number to a string. This would work I guess, but I couldn't get it to work.
I have also read somehting about changing the fields in the MSysIMEXColumns table somehow to allow more decimal places in the exprted text file.
Thanks for helping.
Will
View 1 Replies
View Related
Nov 28, 2007
Hi,
I am trying to multiply £127.65 by 1.175 to produce and store the answer £149.99 in my “answer” field.
I have spent more than a few hours testing different methods, but none so far seem to be suitable.
I used to use the currency data type, however - although the field would show £149.99 – it is stored as £149.98875. So when it comes to adding up each of the “answers”, I am sometimes a penny out because it is adding up the stored number and not the two decimal place answer.
I then changed the data type to “number”, set format to currency, and set the scale and decimal place settings to 2. However this is now not rounding the numbers up correctly and the answer produced is £149.98.
Is there a way I can round up the numbers, and store them as £149.99?
Any help would be greatly appreciated.
Thank you for your time.
Dean
View 14 Replies
View Related
Feb 15, 2006
Hey everyone! Hopefully, someone can help me with this. I've searched the forum and can't find anything on it.
I want to take a number and reduce the number of decimal places from 4 to 3 WITHOUT rounding it. Just chop off that 4th number...I don't care about it.
Examples:
243.4586 = 243.458
22.0541 = 22.054
5.8577 = 5.857
1,587.2556 = 1,587.255
Seeing as how the numbers can be in the 10's, 100's, and 1000's, I can't just use the LEFT function. :D That, of course, would be too easy.
Suggestions? Solutions?
Thanks in advance!
View 8 Replies
View Related
Aug 23, 2006
Hi Guys,
How do I create a number field in my table that can store numbers with 2DP?
I have set the format to both Standard and Fixed before, AND specifed 2DP in the drop-down box. But whenever I go to enter in a value, Access just rounds off the decimal place!
View 2 Replies
View Related
Aug 20, 2013
I have a database that has raw data input to 2 decimal places. There are multiple queries set up to sum the total cost by facility and box type. When the queries are run, the output is to 4 decimal places. I need to round the cost to 2 decimal places. (Right now, it is formatted to show 2 decimal places, but when you click on the number, there can be up to 4 numbers after the decimal.
I have tried to round the numbers within the queries and I get errors asking for parameters. I've also tried to round the numbers in the append queries where I move the final numbers to a summary table. When I do that, I get an error message that the database can't find the table I selected.
I'm not sure how or where it's best to add the rounding function so that my final output is in the format I need.
View 2 Replies
View Related
Dec 21, 2013
I am new to databases. I have set up a simple database but when I enter say 14.75 as a number the database converts it to 15.00. I am not aware of having set any rounding conditions.
View 2 Replies
View Related
