Blank Query Result in a Sub-Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form with SubForm Totals 3
Datediff on form and subform 6
Query in a sub form 1
Calculated fields in main form based on criteria in sub form 3
Access Query problem 1
Prompt for a subform text field 2
Expression in Forms 3
Delay in getting subform total to calculate 2

Back
Top