add column query in microsoft access

i need another column in this query
that subtracts sumofnet sales from the "earned" column minus the corresponding number of "net sales" from the "sandy" chart. the sum of net sales is organized by "jobcode". that new column should be called "difference" or dif for short.