Here is my expression:
HiSKUOH: DSum("[sumofunitsonhand]","onhand-false","[onhand-false.hiskuid]=[replenishment table query.highsku id]")
When I run the query, get error message Invalid Bracketing of Name '[replenishment table query.highsku id]'
"replenishment table query" is the name of the query that I am designing and [highsku id] is a field in that query.
I want the sum of [sumofunitsonhand] in the "onhand-false" table where the [hiskuid] field in the "onhand-false" table is equal to the value of the [highsku id] field in the "replenishment table query". Both the [hiskuid] and [highsku id] fields are text fields.