Search results

Thank you Ranman. I am trying using SUM, hope it works

Hello Everyone! I am trying to find out the difference between two sum using the following query. SELECT Query1.*, Temp.* From ( Query1,Temp inner join Dsum("Amount","Query1",”State =“txtState” AND Type = “txtType” AND Prod = 250 WHERE [Years] <=" & [Years]) - Dsum("Amount","Query1","State...