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?
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 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?
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.
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.
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.
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?
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.
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!
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.
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.
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.
Anyone knows if I can predefine decimal places in a query statement? For example, when I run the select query below, I want the MedicalPremAmt to have two digits after the "." It should look something like this: 12.38
Thank you.
SQL = "Select [Barg Unit], First([Medical Option]) As Carrier, First([Medical Coverage Tier]) As Tier, Sum([Medical Premium Amount]) As MedicalPremAmt,Sum([Total Grant]) As TotalGrant,Sum([Health Allocation]) As HealthAllocation,sum([Medicare Allocation]) As MedicareAllocation FROM RetireeCensus Group By [" & Category & "];"
I have a query with a calculated field as follows: Age: (Now()-[DOB])/365 Even though I have set the property sheet to '0' decimal places, the results are showing about nine decimal places. Is there a way I can get it to just show the age in years without all the decimal places? I'm pretty new to DB and have seen a couple of postings, but couldn't understand how to apply them to this simple situation.
I'm exporting a query that has currency values in with no decimal places but when it's viewed in excel it has 2 decimal places! I've changed the properties in the query to none, how to stop this from happening? I'm using 2003.