Decimal Problem

Jan 17, 2007

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

View Replies


ADVERTISEMENT

Round Up Decimal Point To 4 Decimal Places

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

Decimal Problem

Nov 27, 2005

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

View 3 Replies View Related

Decimal Places

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

Decimal Place

Jan 27, 2007

i have a statement like this:

rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100


how can i have two decimal place?

View 1 Replies View Related

Decimal Contorl

May 14, 2007

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 Related

Decimal Problem

Jul 20, 2007

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.

Any ideas.

View 3 Replies View Related

Decimal Places

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

Decimal Places

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

Decimal Problem

Jan 17, 2007

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

View 1 Replies View Related

Decimal Number

Oct 22, 2007

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?

View 1 Replies View Related

Decimal Number

Oct 22, 2007

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?

View 6 Replies View Related

Decimal Number

Oct 22, 2007

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?

View 1 Replies View Related

Decimal Point

Dec 14, 2005

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.........

View 2 Replies View Related

Decimal Places

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

Auto Decimal?

Jul 21, 2005

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!

View 3 Replies View Related

Why Cant I Get 2 Decimal Places

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

Decimal Places

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

No Decimal Places Box

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

Check For A Decimal Value!!

Oct 19, 2006

How can I check whether an entered value in a textbox is a decimal value or not??

View 2 Replies View Related

Decimal Places

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

Copying Decimal Value Using VBA

Nov 19, 2014

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.

View 8 Replies View Related

Decimal Places Of All Things!!

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

Trim To 2 Decimal Places

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

Adding A Space After The Decimal!

Aug 16, 2006

Hello Everyone :cool: ,

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.

HELP!:confused:

Thanks in advance everyone,

Martian262002

View 5 Replies View Related

Too Many Decimal Places When Merging

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







Copyrights 2005-15 www.BigResource.com, All rights reserved