Dsum Function

[dr223]

Hallo,

I have a subform which comprises of a field called standard_fee (contains the amount of fees) and Session (contains the session period example 2003/04, 2005/06).

A student record might have three Sessions per record for example 2003/04, 2003/04 and 2004/05.

Therefore what I want to do is find the total sum per Session, lets say 2003/04 = 200 $ , 2003/04 = 200 $ , 2004/05 = 100 $. It adds the two 2003/04 and displays 400$ then for 2004/05 displays 100 $.


The main form is called = StudentDetails
Subform is called = FeesDetails
The Fees Amount per Session is stored on a field called = Standard_fee
The Session is called = Session

The code I have been using is;

=DSum("[Standard_fee]","FeeDetails","[Session] = 'Session'")

It brings no answer, meaning the argument is not right!!!!!

Any help will be appreciated.....

 

[pbaldy]

You're summing records where the session field includes the word "Session". See if this helps:

http://www.mvps.org/access/general/gen0018.htm