Make-table Sum of 2 fields in one table

[tquest]

I've taken my query results and put them into a new table with make-table query call AllInOne. I have 4 field query results in in this table.

Fixed_SumOfpremium
NonQualified_SumOfpremium
Qualified_SumOfpremium
Simple_SumOfpremium
Variable_SumOfpremium

All are Currency.

I just want to create a new query to add Variable_SumOfpremium and Fixed_SumOfpremium
For the life of me after trying multiple syntax they won't sum. Any help would be appreciated.

 

[PaulBricker]

The only thing I can think of is that the field names are different than what you are showing.
I know it's a "Duh" but double check what the field names in your table are.

Do you get any error message or anything like that.

Paul

 

[tquest]

I played with it in sql view.. and answered my own question in a matter of seconds.