i have a form with continuous rows a field value returns a number sequence.
the rows will be filtered down.
what i would like to do is get the min and max of the sequence and then filter on a value that i choose so ex.
i could go min 123460 to max 123480
min 123470 to 123480
or min 12354 to 123470
i am not sure how to create that it would have to show on the form the min and max values it found so the user can choose the filter between values.
I guess it would get the recordset close to determine min and max each time a filter was applied.
i am in vba access 2010
The sequence function was created at ID: 38815240