Cumulative total update query "DSum"

[MickeyGreen]

I have an Access table with sales order data and one of the fields is customer "Industry" (i.e. Banking, Manufacturing, etc). I also have a field that I would like to update via the query named "Industry Total" where I want to show the total of all orders in the table that match the industry for that record. I'm using an expression in the "update to" section that I found in the help:

DSum("[Order Total]", "Sales Table", "[Industry] = " &[Industry])

However this query doesn’t update any records “due to a type conversion failure” but both the “Order Total” and “Industry Total” fields are currency type.

Any idea how to get this to work?

Thanks,
Mickey