dcount from two tables.

[prabhus]

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.

 

[JHB]

What about the below?

Text15 = DCount("[client]", "[MasterTable1]", "[Confirmed]=Yes and [Assigned]=No")+DCount("[client]", "[MasterTable2]", "[Confirmed]=Yes and [Assigned]=No")

 

[prabhus]

Thank you Sir, Perfect!!!