[AccessD] Datasheet Filters

[Rocky Smolin]

Well, I've got space in the footer of the main form, so that's where ll
those calcs will go.

r

On Mon, Mar 13, 2023 at 10:33 AM John Colby <jwcolby at gmail.com> wrote:

> If you have the room, you could add a second form below the first.  Add
> controls in there with whatever kinds of math you want.
>
> On Sun, Mar 12, 2023 at 7:41 PM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > Dear List(s):
> >
> > I have a subform in datasheet format on a main form.  Several of the
> fields
> > on the subform are currency fields.
> >
> > The client wants sums and averages on several of those fields. I
> explained
> > that you can't do that with a datasheet but that in the footer of the
> > parent form I could give him all that data but the sum and average won't
> > line up under its column.  No problem for him.  He's happy with the data
> on
> > the footer.
> >
> > Since they will be using the filters on the datasheet fields to
> > restrict the data to just that they're interested in, that, obviously,
> will
> > change the values of the sum and averages as they apply different
> filters.
> >
> > What I need then is a way to see what the filters are, and generate a sql
> > statement with those filters as the source of the sums and averages.
> >
> > Q: Is there a way to poll the filters on those fields? I don't know of
> one.
> > But I'll bet there is one.
> >
> > MTIA
> >
> > Rocky
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>