Hi,
I have the field set to number -> decial and places to 2.
The CSV document reads 96.133542682
So once imported it should look like 96.13
but it doesn't it is just 96.
Why is this? when the field is text it is the 96.133542682 as it should be.
Thanks
k0r54
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?
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!
If you specify Number as data type and Decimal as field size for a field in an Access table, will it actually store numbers to the right of the decimal point? I have never been able to get this to work or find these value if they are there and have alwayshad to use field size single or double or data type currency.
View 7 Replies View RelatedI've been looking into writing an access form used for hard drive analysis and came across hex values. This made me start dabbling with numbers again and came up with the following function.If you're a person that enjoys playing with numbers, could I get you to think of any scenarios where I could solidify this function to handle errors and become as dynamic as possible!
I think the end result could be useful to add to this communities quick fix library. What it does is take two strings, value and and the definition of how that numbers counts, and with these two values it will spit out the decimal value.
examples:
HEX - "FFF", "0123456789ABCDEF"
OCT - "777", "01234567"
BINARY - "11111110", "01"
Code:
Public Function ConvertStringToDecimal(ByVal str As String, _
ByVal def As String) As Variant
Dim inc As Integer: inc = Len(def)
Dim n As Variant: n = CDec(0)
Dim i As Integer
Dim val As Integer
[code]...
I have Access 2000. I want to update all my records in one table so that they only have 2 decimal places instead of the 10 they have now. What is the expression used to do this?
Thanks
Chad
I have a field for Item Price.
It would be a currency field, but I want it to be able to work with up to 6 decimal places. currency only seems to handle 4.
So, in the table, i changed it to a Single.
In the form, I left the control on Currency.
If I type in $1.43, instead of storing $1.43000000 it stores $1.43003243953
Why is it adding all these bogus sub decimal numbers? Any clue?
Thank you,
Evan
I have a pivotchart which I cause to take a huge list of people's test percentiles and calculate the average for each year. I then display the average above each bar. The problem is that there are too many numbers after the decimal place for each figure. I went into the properties and changed the number format to "fixed" but it doesn't give me the option to change the number of decimal places that are used (it does every where else in MS Office!). It seems that it just uses the regional settings for the computer. But the problem I have in changing that is that I have other pivotcharts in the same report that does something similar but needs a different number of decimal places. Is there any way around this without having to create another query to calculate the average and then having the pivotchart display the info from the new query (this is a huge database that I put together with many charts and I don't want to have to redo the way that it works just because of this decimal place issue)?
View 1 Replies View RelatedI 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.
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
I am importing a delimited .txt file that has a number field. A value for a record coming in is 36,767 and Access is not accepting it. If I redefine the field as long integer or as double, I can manually update the record, but as soon as the file containing the record is imported, the field reverts back to integer.
How do I format the field with VBA so that Access will accept the value and not revert to integer?
I am importing information into a table from excel. The number is formatted correctly in excel and is displayed as 10309976464180, but when it is imported into access it displays as 1.030998E+13. I have tried all of the possible formatting for numbers but nothing corrects this, and if I change to Long Integer it actually removes the numbers. What is the correct formatting in Access to get these numbers to display correctly?
View 2 Replies View RelatedI 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!!!
THANK YOU!!!!!!
LL
i have a statement like this:
rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100
how can i have two decimal place?
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?
View 5 Replies View RelatedIs 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.
Any ideas.
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
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
Hi guys,
just a short question,
I want my autonum. to be in 3 decimals:
001
002
003
004
etc.
Someone has a suggestion??
Thanks a lot.
Stefan
Hi guys,
just a short question,
I want my autonum. to be in 3 decimals:
001
002
003
004
etc.
Someone has a suggestion??
Thanks a lot.
Stefan
Hi
I have data numbers:
1500
60000
8900
How can I put a decimal point two from the right ie:
15.00
600.00
89.00
Thanks.........
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.
Any help for a newb would be great!