Summing two fields in a query

[Jarad]

I have 2 fields, Accounts, Accounts CMO. I need those two fields to show in the same table in a new field called Total Accounts. I am summing them, but getting irregular results, some are right, and some are 4 times more than they should be? How would you go about doing this, maybe I am missing something.

 

[RuralGuy]

A new field in the query: [Total Accounts]:=[Accounts]+[Accounts CMO]
Embedded spaces in names drives Access nuts.