#Error in form on sums of query (1 Viewer)

[ssvec]

I am using a query to populate a continuous form, in the form footer I am adding fields that total the results of the query. This works fine for a while then I will start getting #Error in the total fields only. The form displays rows of invoice numbers and cash, I total the cash with Sum([cash]). The form uses the query as its record source.