Hello!
I have a database problem, Access 2000 - 2003.
The probles is as follows:

I have to tables.
one is called HuvudAktivitet and the other UnderAktivitet.
the first one has 4 columns:
1: HuvudAktivitetNr Counter [PK]
2:TotalTime number
3:TotalOverTime number
4:HuvudAktivitetsNamn Text(50)

the second has moore columns:
1:UnderAktivitetsNamn Text(50)
2:MaxTid number(double)
3:ArbetadTid number(double)
4:VarningsTid number(double)
5:OverTime number(double)
6:Progress Integer
7:Comments text(250)
8:HuvudAktivitetNr counter[fk]

Problem.
in table 1, i only insert the number and name, i leave TotalTime and TotalOverTime to be 0.
I want to get the Sum from ArbetadTid and OverTime in table 2, and get them in to the columns i table 1.(TotalTime and TotalOverTime)...

can any one help me please!!!!!

you can problaby try an update statement something like one listed below I was not to sure on what you had. Tables my need to be switch around. I will recreated your tables and come up with with the proper syntax. This may start your think.

UPDATE HuvudAKtivitet INNER JOIN UnderAktivitet ON HuvudAKtivitet.HuvadAktiviteNr = UnderAktivitet.HuvudAktivitetNr SET UnderAktivitet.Arbetadtid = Sum(CCur([arbetadtid])), UnderAktivitet.Overtime = Sum(CCur([Overtime]));

ok, i will try that. thanks for the help

Hello!
The command did not work. anyone else who got any ideas?