Domain aggregate function

• kiberu

  SSC-Addicted

  Points: 496

  More actions

  July 21, 2003 at 12:10 am

  #466141

  Hi, all

  I have abandoned the previous post.Now ->

  How do you put a calculated value eg. sum of all entries in the footer of a data entry form in Access DataProject?

  Regards

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  July 21, 2003 at 12:38 am

  #466145

  Hi kiberu,

  quote:

  ---

  How do you put a calculated value eg. sum of all entries in the footer of a data entry form in Access DataProject?

  ---

  DSUM should be the easiest way for this.

  However, another method would be to utilize the AfterUpdate Event of the form (or subform), open a recordset, fire the SELECT statement, and place the returning value into the control. Basically the same what DSUM does.

  ..another way could be to update this running sum only on users' request, maybe by hitting some command button.

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]