I attach a file. In this file I make a querie. all the (data) field of both tabel show in the querie. I want all data will add up in querie.
I mean a calculate field. like : (200,200,300) this amount was in both table. in querie it will show 700.
any body can help me with modify this attach file.

check it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.