Make Row Total appear in Sub Form

[John]

I have created a subform that displays products, qty and unit price in a
datasheet view. I then created a new field that calculates QTY * unit price.
This columb is called Subtotal.

I then created a text box field with a SUM calc to determine the grand
total of the Subtotal columb. This text box works fine and has been placed
in the footer secition of the subform, but I need to make it appear in the
datasheet view on the subform or look for another way to display the grand
total.

How do I display the grand total so it is viewable on the subform in
datasheet view

 

[Damon Heron]

You don't. Think of datasheet view as opening up a table and viewing its
contents. What is wrong with viewing it on the main form?

Also, you seem to be saying (I am not sure) that you created a calculated
field (Subtotal) in your table. That is considered poor practice. There is
no reason to save calculated amounts, since the display on a form or reports
is all that is needed.

HTH
Damon