[AccessD] Datasheet Filters

[Stuart McLachlan]

> > 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
>