Sum field in Form Footer

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

Guest

Hi,

I have a subform that has several fields on it. I would like the field
Total Cost, which is not a calculated field, to be summed in a unbound field
in the form footer. I can make this happen with no problem. However, as I
enter information into the
records, I have to move to a new record to have the Sum actually add
together all of the records. Do you have a quick way to have the summed
field in the footer, keep up with record entry without having to move to a
new record?

Thanks.
 
No. The total will not update until the record is saved.

It would theoretically be possible to set up an expression something like
this if it is really crucial:
=Nz(DSum("[Total Cost]", "MyTable", "(([MyForeignKey = " &
Nz([MyForeignKey],0) & ") AND ([MyPrimaryKey] <> " & Nz([MyPrimaryKey],0) &
")"),0) + Nz([Total Cost], 0)

A much more important question might be why the Total Cost is not a
calculated field. Unless you are intentionally under- or over-charging, that
sounds like a really bad idea.
 

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

Back
Top