Share
ReportIs 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.
All responses (
Answers (
1,430
