In Access, is it possible to write a query that sums up a column, but skips over rows that are not numeric so that it does not return a datatype mismatch error?

Thank you.

You will need to create a query that eliminates those records first before doing the Totals query. HTH.

theDBguy is right and this is one way you might do that...

select sum(field)
from table
where isnumeric(field) = true

Or you can use iif() to skip over just the values in that field without eliminating that record entirely if different fields will have null in different records. Like below:

select sum(iif(isnumeric(field), field,0)) as sumoffield, sum(iif(isnumeric(field1), field1,0)) as sumoffield1 from table