[AccessD] Quarter hour increments

Hi Gina

Thanks for the clarification. 
You are right - rounding just doesn't make sense in this situation. 
Here where things have to fit, the method of choice is "polite and bruce force" ...

/gustav

>>> hoopesg at hotmail.com 24-10-2005 17:29 >>>
Scott and Gustav,
I've been reading your comments with interest. I agree with Gustav on the 
theoretical level because I'm a trainer and I do try to make things as 
friendly as possible for the end user. However, in this particular case, 
Scott's solution is still the best. The user has a maximum of 40 hours that 
s/he can enter. So if I allow them to prepare their own breakdown, usually 
in an Excel spreadsheet, when they come to the database to enter their final 
result in my database the rounding would change their total. In this case 
the user needs to know that the only acceptable increments are quarter hours 
and prepare their data accordingly. This is a new restriction for them so we 
need to re-train their process rather than "fix" the data they enter.

Thanks for a good discussion with more than one good solution.

Gina