Blank Query Result in a Sub-Form

L

las

I have a simple query which uses the CCur expression to calculate a total.
After the query runs the total is shown. However when I built a subform from
the query the calulated field is blank in the subform.

I have tried this as a text control and as an included field and cannot get
the result to appear. There are sveral of us here baffled.
 
K

Klatuu

Are you using ItemDelta as the name in the control source of the control on
your subform?
 
K

Klatuu

Oops, hit Post too fast.

If you are using ItemDelta as the control source and it is not working, try
removing the calculated field from the query, but include ItemQtyRec and
ItemQtyOnOrder.
Create invisible fields for them in the subform. Then create an unbound
control that does the calculations on the control names.
 
Top