sum

[dollygg]

Hi ,

I have table that have 4 columns(Fund, SM, Account number, quantity), Now I want to add one more column called sum. The following is the result that I would like to achieve. Any suggestion?


Table :

Fund SM Account Number quantity sum
123 1 abc 10 25
123 1 def 15 25
111 2 abc 8 17


111 2 def 9 17

[maximus]

Now although You have not provide to many details I have done some thing. Attached is a screen shot of a query and a sample mdb file with one table and one query.

Table name: SumProblem
Fields:
ID Autonumber PK
Fund Number
SM Number
Account Text
Quantity Number


Now I have a Query SumProblem Query
I have added a calculative field Sum

Sum: DSum("[quantity]","SumProblem","[Fund]=" & [Fund] & " And [SM]=" & [SM])

scope of this Filed:

It will give you the Total sum of Quantity for A particular Fund with a same SM Number:

if this solves your problem mark the thread solved.

[maximus]

is your problem solved if yes mark this thread solved.