Totals Query

[hotstream]

Hello, the best people!

I have 2 tables (queries): tblGroup1, tblGroup2
tblGroup1 fields: ID, Date, Totals_1
tblGroup2 fields: ID, Date, Totals_2
Primary Keys in each table are ID and Date
Also known, that tblGroup1>=tblGroup2 on Primary Keys: If Totals_2.id and Totals_2.date exist, then they exist in Totals_1.


I want to build another table (query) qryAllGroups with fields:
ID, Date, Totals_1, Totals_2

If tblGroup2.Totals_2 not exists for tblGroup1.Id and tblGroup1.date it must be 0 in qryAllGroups.Totals_2.

How can we do it?

Thanks