How do I get a total on a subform?

[drossie]

I want to SUM a line total on a subform similar to a order entry database where items are totaled and the subtotal is displayed.
I have tried to set it up similar to the order entry template but i cant get the subtotal.
The line i tried so far is:
=nz(Sum([Line Total]))

any suggestions?

 

[ChrisO]

Drossie, I will try to answer this as tactfully as I can.

It is not appropriate to PM members in order to get a quick or personal response.

Reasons…
1.)This is a public forum and the answer may be applicable to more than one question.
2.)Expecting a “bypassing of the boards criteria” would require other members to wait.
3.)Your profile indicates that you have not even taken the time to introduce yourself to other members.

What I would suggest is to go back and rethink your, and our, position.

Hard nosed? Sure.
Correct? I think so.

Regards,
Chris.

 

[drossie]

ah, ok then
i guess i'll follow the protocall.
i saw only 3 names on the forum so i thought i'd give it a shot.
didnt mean to bother you

 

[stormin_norm]

Creating a text box TOTAL with recordsource=nz(sum([LineItem])) should work fine.
Just make sure it is in the Form's footer (turn on page header footer by selecting from access menubar: view...Page Header/Footer)