Hi,
Perhaps a rare (or stupid request) as cannot find anyone else asking.
Trying to find a way to get Min & Max values of a field on a continuous form that is not necessarily base on a query.
Seemed simple & quickest to me to use recordsetclone somehow but does not seem a way.
I have wanted this before but currently..
I have a form that is based on a query but I use me.filter on it also so cannot use Dmin etc on the query. I quess I could, but don't really want to make a whole SQL to replicate the current source of the form including an filters but again just seems ott.
I could also put it into a table & DMin but again seems ott.
Is there an easy to do this?
I guess I could .sort the RS for first & last but still seems a little unnecessary and whilst quite a small RS I imagine slow'ish.
Thanks I/A
Perhaps a rare (or stupid request) as cannot find anyone else asking.
Trying to find a way to get Min & Max values of a field on a continuous form that is not necessarily base on a query.
Seemed simple & quickest to me to use recordsetclone somehow but does not seem a way.
I have wanted this before but currently..
I have a form that is based on a query but I use me.filter on it also so cannot use Dmin etc on the query. I quess I could, but don't really want to make a whole SQL to replicate the current source of the form including an filters but again just seems ott.
I could also put it into a table & DMin but again seems ott.
Is there an easy to do this?
I guess I could .sort the RS for first & last but still seems a little unnecessary and whilst quite a small RS I imagine slow'ish.
Thanks I/A