sum by a query- force feild type in a make table query

[sona]

Dear All,

I have an input file as seen in the attachment. What i want to do is sum the values in two columns together.

Right now i have used query1. however it is not giving the correct output. I have made a table for the correct output named as 'required output'.



What i am guessing is that it is not summing properly since the data in the 'input' table is in text form.

Maybe i can use a make table query where i store the data of input as it is again but by forcefully defining the fields as number. Can you please tell me how to do this

[recyan]

Perhaps :

SELECT 
CInt([shoes]) AS TheShoes, 
CInt([clothes]) AS TheClothes 
INTO 
newTable
FROM 
tblinput;

Thanks