Running totals in forms

[Guest]

Is there a way I can create a field that calculates running totals on my form
without using visual basic.
I have say the following fields :
" Hospital A OPD Income"
"Hospital B OPD Income"
"Hospital C OPD Income"

This will be in a table whose primary key will be the date field as I have
to enter these datas daily.
Now I will make a query on the same fields, but the fourth field that is the
"Total for the day" instaead of a summ function I want it as a running total,
so that I can see the toatal for that day till that day.
Then I will base my form on this query.

Can I do it without using VB?

Thanks

Dr Alok Modi MD

 

[Guest]

from Rainbow01 Hong Kong

try DSum function
u can see more information in Access Help

"Dr Alok Modi MD" 來函：

 

[Guest]

Thanks for the input, but one thing about access is that the help is very
poor in expalining how to use the functions. How can I use the DSum function
to calculate a running total? If you could be kind enought o show me with an
example ?

 

[Guest]

e.g. here a table (ProductDetails)
one of column call Quantity
assume have 10 records and all quantity is 10

DSum("Quantity" , "ProductDetails")
the above can sum up 10 records' quantity to one total numner --> answer is
100


"Dr Alok Modi MD" 來函：

 

[Guest]

Yes, but is this running totals?

e.g. here a table (ProductDetails)
one of column call Quantity
assume have 10 records and all quantity is 10

DSum("Quantity" , "ProductDetails")
the above can sum up 10 records' quantity to one total numner --> answer is
100


"Dr Alok Modi MD" 來函：