[AccessD] Datasheet Filters

[Stuart McLachlan]

I've just sent Rocky a small demo off-list since we can't do images or attachements here :)

On 13 Mar 2023 at 13:12, Stuart McLachlan 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
>