Skip to Content
0
Former Member
Sep 01, 2007 at 06:29 PM

help in doing sum fields from tables

17 Views

HALLOW

i have a table and i wont to add the tables line to one line , to do sum

if date appear more then one time like in example.

i give example

date----


hours

01.01.2002 6.5

01.01.2002 2.5

02.01.2002 5

03.01.2002 3

03.01.2002 3

04.01.2002 4

06.01.2002 5

i wont to move it to table like this

date----


hours

01.01.2002 9 ->sum houres of date 01.01.2002

02.01.2002

03.01.2002 6 ->sum houres of date 03.01.2002

04.01.2002 4

06.01.2002 5

Regards

i reward