Another possibility is this: If the [Final Price] does not contain a value in every record then the result will be #Error as Access cannot Sum a null. I would suggest that you add a further condition to your query controlsource for [Final Price]. Something along the lines of iif(isnull([Final Value],0,[Final Value]) so you don't have any empty fields being summed.

Just a thought.