Is it possible to obtain running sequence number of the filtered data of gallery.
I am planning insert TextInput and apply a code, so the user can see by sequence number and also can note the total records filtered.
Currently I manage to inform user for total records by the help of notify and rowcount() function
In MS access I use do the below to obtain this :
SELECT Nz(DMax("RecoID","TblLimit),0)+1, LimitCheck1.VendorNo, LimitCheck1.FormNo, LimitCheck1.DoNo, LimitCheck1.DoDt, LimitCheck1.ExtPrice FROM LimitCheck1;
To Note : RecoID was the not the field in the Table, it was just declared in the query
Kindly advise, if any such method can be used to achieve the requirement.
