From: forest8 on 25 Mar 2010 22:25
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
> 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