[AccessD] Datasheet Filters

John Colby jwcolby at gmail.com
Mon Mar 13 12:33:37 CDT 2023


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


More information about the AccessD mailing list