addinf numdata from 2 queries

[pantanna]

i have 2 queries

qry 1
________

id nr
date
t1
t2
t2
t3
total a t1*t2
total b t3*t4
summary1 totala+totalb

qry2
________
date
r1
r2
r3
r4
ra
rb
rtotal a r1*r2
rtotal b r3*r4
summary2 rtotala+rtotalb

the relationship in the tables is one to many with using the id nr in the according tables
the question is:
i would like to add summary 1 + summary 2

the results come our calculating a many times a the days are so i never know which the exact nr is....
it seems so easy... where is the mistake?

thanks for your help

 

[vbaInet]

Your tables aren't understandable but based on what you asked I can only assume you want:

Val(DLookup("Field", "Query1")) + Val(DLookup("Field", "Query2"))

http://www.techonthenet.com/access/functions/domain/dlookup.php
http://www.mvps.org/access/general/gen0018.htm