ExcelBanter - Some columns exported from Access do not sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Some columns exported from Access do not sum (https://www.excelbanter.com/excel-discussion-misc-queries/119615-some-columns-exported-access-do-not-sum.html)

JoeA2006

Some columns exported from Access do not sum

I have written a query in Access ,using a sum function on some of the
columns. I am unable to sum these columns in Excel but I am able to sum the
others. What is the reason for this? Do I need to change something in the
spreadsheet or my query?

All times are GMT +1. The time now is 08:26 PM.