[AccessD] Datasheet Filters

[Rocky Smolin]

Well, it was a good idea - one that I didn't know even existed. Never fails
to amaze how many years I can be using Access and there are still basic
things I never knew, never had a reason to use.

In this case the users of the app are so used to their spreadsheets that my
client wanted that datasheet UI so they'd feel comfortable and would use
the system instead of working around it. I support that - the client
usually knows their user community better than the developer.

So the total line on the datasheet is now in my toolbox.

Tks

r

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

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