Work out totals from a query field

Vo0do0uk

Registered User.
Local time
Today, 08:34
Joined
Apr 24, 2004
Messages
32
(look at jpeg!)

So i've got total mins worked which can be formated into hours/mins later. i need to work out the total mins for one date eg 07/05/2004 this would be i think it's 480+240 or whatever.

anyway - i can't find a way of adding these totals together

please advise! :eek:
 

Attachments

  • totalminsquery.JPG
    totalminsquery.JPG
    37.5 KB · Views: 153
I've worked it out!!

(in case anybody cares)

all i needed to do was create a new query, put in the dates and the total mins for each employee

then as the total for the total mins set this as SUM

voila

:D
 

Users who are viewing this thread

Back
Top Bottom