I have two querys with same number of fields and same field names. [BudgetNumber] txt
[CostCategoryCode] number
[TotalSum] number
I need a query that calculates balance between these two querys. It should look like this, BudgetNumber (match with both querys), CostCategoryCode- all codes that are present in either of querys. TotalSum of both querys (two fields) where BudgetNumber and CostCategoryCode matches. If in one query the CostCategoryCode doesn´t exist, the field should be displayed anyway and the TotalSum field of that query will be just Null. Crazy explanation but i home someone can help me.
olxx
[CostCategoryCode] number
[TotalSum] number
I need a query that calculates balance between these two querys. It should look like this, BudgetNumber (match with both querys), CostCategoryCode- all codes that are present in either of querys. TotalSum of both querys (two fields) where BudgetNumber and CostCategoryCode matches. If in one query the CostCategoryCode doesn´t exist, the field should be displayed anyway and the TotalSum field of that query will be just Null. Crazy explanation but i home someone can help me.
olxx