Ervin Brindza
viner at eunet.yu
Mon Dec 15 06:15:29 CST 2003
Hi,
the situation is: there are 3 tables:
tblMain(Id, fldDate)
tblFirst(Id, fldItemId, Amount1, Amount2)
tblSecond(Id, fldItemId, Amount3, Amount4)
The tblMain is on the 1 side, and tblFirst and tblSecond are on the many side.
And there is a need for summing only those records (all of them) where are the sum of Amount1>0 or Amount2>0; and Amount3>0 or Amount4>0
E.g.
tblMain
1 01/01/2003
2 02/02/2003
(I'll use ItemName instead of ItemId)
tblFirst
1 sugar 1.00 2.00
1 salt 3.00 4.00
2 sugar 10.00 12.00
2 water 13.00 14.00
2 pepper 0.00 0.00
tblSecond
1 sugar 11.00 2.00
1 salt 3.00 4.00
2 sugar 10.00 12.00
2 vine 23.00 24.00
The report should show all used ingredients and sum the aomunts separately:
1 sugar 32.00 28.00
2 salt 6.00 8.00
3 water 13.00 14.00
4 vine 23.00 24.00
May I use union query, subreport or something else?
Many TIA,
Ervin