Find difference between multiple fields in two tables

[klallen810]

I have a database with two tables, one for the amount that was estimated in each cost section, and one for the actual amount billed for each cost section. The tables have the same number of fields, all with the same names. They can be linked together with event ID. Each table has over 100 fields and I would like to find the difference between what was estimated and what the actual was for each event. I would also like to see which cost section has the most and least variance. I am trying to do this without going through each cost and putting [tEst].[CostName]-[tActual].[CostName]. Any ideas?

 

[Monardo]

when you say each table has 100 fields, do all 100 contain costs? do you have to substract 100 fields from another 100 fields from another table, is that what you mean?

 

[klallen810]

Yes. For example, for each event costs might incur such as linens, set up fee, catering, glasswear, etc. Each has a specific cost tied to it and goes into a different cost code for accounting purposes. I would like to analyze these costs to see which cost contains our largest variance as well as the differences in amounts from estimated to actual.