| re: Filtered by form - differences between totals.
Hi Reggie,
I'm sorry, I feel I made my question a little unclear.
I can write a separate query to get the Max / Min values of the field
'Volume'. I am unsure of how to integrate this with the current
records of the subform and get the difference of these values into the
subform footer text box.
Thank you for your time.
Regards
Karl
"Reggie" <NoSpamreggie@NoSpamsmittysinet.com> wrote in message news:<u9CdnQnXa7dp_G_dRVn-gg@comcast.com>...[color=blue]
> After your min/max values are set have you tried to requery the text box?
>
> Me.myTextBox.Requery
>
> --
> Reggie
>
> ----------
> "Karl Roes" <karlroes@hotmail.com> wrote in message
> news:7cc66112.0407112147.7484f2f8@posting.google.c om...[color=green]
> > Hi All,
> >
> > I would also like some help with form filtered differences in totals.
> >
> > I have a main form for the client, and a continuous subform listing
> > client transactions. The subform can be filtered by several fields. I
> > have set up several text boxes which programatically show various
> > OnCurrent subtotal details depending on the filtered options in the
> > continuous subform.
> >
> > I wish to populate one of the form footer subtotal text boxes with the
> > value of the difference between the highest and lowest amount as
> > currently shown in the field 'Volume' at any time.
> >
> > I can produce a Max / Min value, but the OnCurrent calculation and
> > subsequent population of this text box is difficult - or is it?
> >
> >
> > Regards
> >
> > Karl[/color][/color]
| 
