Do not rund up or down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box that the user wouls like to put billing hours. I would like
it not to round the number up. At this time if I put in 1.25 it gets rounded
up to 2.00.

Please help!

The Format for the text box is as follows:
Format: Fixed
Decimal Places: 2

Tnanks
 
1. Open the table in design view.

2. Select the problem field.

3. In the lower pane, set the Field Size to:
Double
The integer types can handle whole numbers only.
 
THANKS Allen !!!

Allen Browne said:
1. Open the table in design view.

2. Select the problem field.

3. In the lower pane, set the Field Size to:
Double
The integer types can handle whole numbers only.
Click to expand...
 
I would suggest you first look at the range of data that will be entered,
and if possible use the SINGLE field size in place of the DOUBLE field
size; as shown below:

Single Stores numbers from
?3.402823E38 to ?1.401298E?45

for negative values and from
1.401298E?45 to 3.402823E38 for positive values.

Decimal Precision - 7 places
Storage Space - 4 bytes

####################################################

Double Stores numbers from
?1.79769313486231E308 to
?4.94065645841247E?324

for negative values and from
4.94065645841247E?324 to
1.79769313486231E308 for positive values.

Decimal Precision - 15 places
Storage Space - 8 bytes

####################################################

As you can see, the SINGLE field size will take up half as much space.
whilst this may not be a main factor in your database, it is always
recommended to use the smallest field size possible; databases rarely stay
small!

Cheers

John Webb
 
Back
Top