Hi I am trying to calculate the sum of several intervals over a period of
months/yers

Imagine a machine i stopped by fault for say 3 minutes
and I have many machines with different fault-periodes (same day)

I vould like these periodes to be summed for the, and all the days so summed
for a month
Problem is, I can not find a way to tell Access that there is 24 hours i a
day/night

So Access start over when the sum =24

CAn anyone please help.
Sorry for the broken English

But you don't have to do the addition as a time function.
If you have 3 minutes for item A and 10 minutes for item B you can
just add them to a long integer.
When you've added up everything you can disply the total as minutes or
divide by 60 for hours or divide by (60*24) to get days.

Held og lykke
Ira Solomon

Note: It is my wife who knows Danish, not I. But she knows nothing
about computers.


On 28 Feb 2005 14:53:09 +0100, "Anders Nielsen"
<a.nielsen-126 (AT) tele (DOT) dk> wrote: