Full Version: Agregated functions in subform
UtterAccess Forums > Microsoft® Access > Access Forms
Henderson
How can I use agregated functions in continuos subform.
Bob_L
Sorry, but can you give a little more specific example of what you're wanting?
Henderson
In a continuos subform:
filter for Date
ProductID Date In Out Total
1 01/01/07 10 5 5
2 01/01/07 10 2 8
. . .
Bob_L
To get an agreggate total for the Total field, you can put a text box in the form footer of the subform and put:
Sum([Total])
but if the In and the Out are numbers then you can do:
=Sum(Nz([In],0)) - Sum(Nz([Out],0))
if that is what total is supposed to be, which it looks like on your example.
Henderson
I'll try this code
Thanks
regards
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.