[AccessD] Datasheet Filters

[Rocky Smolin]

Are you limited to one line? I need two lines - one of total, the second of
average.  Is it possible?

Tks

r

On Sun, Mar 12, 2023 at 8:12 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> > > The client wants sums and averages on several of those fields. I
> > explained that you can't do that with a datasheet
>
> Yes You can.
> Open the subform in Datasheet view, select the "Home" tab, Click on Totals
> in the Records
> ribbon menu block.
>
>
>
>
> On 12 Mar 2023 at 16:41, Rocky Smolin 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>