Prev: Appearance of responses in a list box
Next: Create a button that prints the selected record of a report
From: forest8 on 25 Mar 2010 16:07 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
From: KARL DEWEY on 25 Mar 2010 19:20
>>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 |