Exclude Column from Total Sum

G'day Everyone,

Uncle Google won't tell me how to exclude (ignore) a column from summing within a query.

I have 2 tables. One is 'Goods_In', other one is 'Goods_Out'. Through the Access wizard query I have used the 'Find Unmatched Query Wizard' to create a stock on hand queries. This column I'm trying to exclude is the primary key (customlised barcode number) of the query table. Now all I need to do is total the products. But how ?

Side note: All information is import via excel workbook as I'm dealing with third party inventory as well.


Edit
Cross-posting due to no responds - http://www.accessforums.net/showthread.php?t=76125

Solved

All I had to do is make that trouble column as a 'Sum' column, then it worked. Then after realising this, I started with a fresh database and when I was generating the 'Find Unmatched Query Wizard' I learnt that I could leave the column that was giving me trouble. Fun had by all.