sum

  • Thread starter Thread starter BB
  • Start date Start date

BB

Registered User.
Local time
Today, 21:54
Joined
Aug 31, 2001
Messages
30
How can I do something like this in code?

Sum(price*quantity)

Thanks(very new to access/VBA)
 
No. You can only use aggregate functions when the domain is known such as in a query, a control on a form, or a control on a report. You can however use DSum() which is a domain aggregate function. The difference between the two is that in a "domain" aggregate function such as DSum(), you specify the domain that the function is to operate on in addition to the field. Look it up in help.
 

Users who are viewing this thread

Back
Top Bottom