[AccessD] Datasheet Filters

[Stuart McLachlan]

Sorry, just one Totals line using built in Access Datasheet capabilities.


On 12 Mar 2023 at 20:58, Rocky Smolin wrote:

> 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:12PM 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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com