|
| 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
March 25th, 2010, 08:07 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
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
March 25th, 2010, 11:20 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
March 26th, 2010, 02:25 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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 | |
|
|
Linear Mode
