yes am getting my answer i used Manual: Nz([manu].[Man])+Nz([manu1].[Man1])
I got it !!!!!!
Thankfully, Microsoft Access offers a way around this issue in VBA module code
or queries. The NullToZero function (NZ) takes a null value and converts it to
zero. You should use this function anywhere a value could be null (like a field
that is not required).
since in my case after join operation their were null values so it was giving me the answer null
Thanks a lot for your precious time ajax!!!!!