MS Access, automated updating query
<p>I have a query which shows many other columns even though they are the same thing,</p>

<p>For example if I have my column names : "Breast Imaging" and "BREAST IMAGING" with the numbers of "6" and "8" </p>

<p>although they are the same things they are differentiated by two other columns with two other numbers, how can I sum up those columns automatically? do I have to use updating query? </p>

<p>For example : if I have a query like</p>

<p>Name / Total number of scans / Breast Imaging / BREAST IMAGING / CT / MRI</p>

<p>Arvin /         16          /       6        /       8        /  1  /  1 </p>

<p>How can I make it like </p>

<p>Name / Total number of scans / Breast Imaging / CT / MRI</p>

<p>Arvin /         16          /       14          / 1  /  1  </p>

<p>I made the tables with the crosstab query wizard</p>