In my form, i would like to sum and dispay the values of datas from two different tables.
Table1: MasterTable1
Table2: MasterTable2
I use the below code for one table and its working.
Text15 = DCount("[client]", "[MasterTable1]", "[Confirmed]=Yes and [Assigned]=No")
But i want to sum the same criteria from MAstertable1 & Mastertable2 and display the data.
Please help.
Table1: MasterTable1
Table2: MasterTable2
I use the below code for one table and its working.
Text15 = DCount("[client]", "[MasterTable1]", "[Confirmed]=Yes and [Assigned]=No")
But i want to sum the same criteria from MAstertable1 & Mastertable2 and display the data.
Please help.