If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set it up so that the table and form shows 2 decimal plac
Hi
In my database, I have a field that deals with time spent on an activity. The desired time interval is 0.25 for every 15 minutes. For example, if a person spent 30 minutes on an activity, I want 0.5 to be the value. What is the proper way to set this up? I tried Fixed, General, Scientific. The number entered is always rounded up. Thanks |
#2
|
|||
|
|||
How do I set it up so that the table and form shows 2 decimal plac
I tried Fixed, General, Scientific.
Open your table in design view and check the properties for your number field to see if it is Number - Long Integer. If so then change to Single or Double. -- Build a little, test a little. "forest8" wrote: Hi In my database, I have a field that deals with time spent on an activity. The desired time interval is 0.25 for every 15 minutes. For example, if a person spent 30 minutes on an activity, I want 0.5 to be the value. What is the proper way to set this up? I tried Fixed, General, Scientific. The number entered is always rounded up. Thanks |
#3
|
|||
|
|||
How do I set it up so that the table and form shows 2 decimal
Exactly what I needed. Thank you.
"KARL DEWEY" wrote: I tried Fixed, General, Scientific. Open your table in design view and check the properties for your number field to see if it is Number - Long Integer. If so then change to Single or Double. -- Build a little, test a little. "forest8" wrote: Hi In my database, I have a field that deals with time spent on an activity. The desired time interval is 0.25 for every 15 minutes. For example, if a person spent 30 minutes on an activity, I want 0.5 to be the value. What is the proper way to set this up? I tried Fixed, General, Scientific. The number entered is always rounded up. Thanks |
Thread Tools | |
Display Modes | |
|
|