I'm having trouble with an update query that says it cannot update the field because of a type conversion failure. The field in my table is set as currency as well as the source field from the query.
I'm using this SQL:
"[batch].[total]-Sum[qryBreakfasts].[amount]"
Any suggestions?
I'm using this SQL:
"[batch].[total]-Sum[qryBreakfasts].[amount]"
Any suggestions?