[AccessD] Datasheet Filters

[Rocky Smolin]

Looks like I'm going to have to go with the totals and averages in the
footer - that's OK with the client.  Might have a use for a union query
there.

Tks

r

On Mon, Mar 13, 2023 at 6:19 AM Ryan W <wrwehler at gmail.com> wrote:

> Oh bah. PEBCAK.... not enough caffeine.
>
> The union works until you filter the datasheet, then the unioned parts get
> filtered out.... laughing at myself right now.
>
>
> On Mon, Mar 13, 2023 at 7:39 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > I wonder if you could get away with a couple union queries to tack on
> your
> > total and average lines at the bottom of the datasheet view?
> >
> > Of course with the filters you'd have to figure out how to turn the
> filter
> > data into a where statement, which probably won't be terribly difficult
> as
> > long as your control fields are named the same as your backing table
> fields.
> >
> >
> > On Sun, Mar 12, 2023 at 10:58 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > 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: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
> >> >
> >> --
> >> 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
>