After googling i have got the solution and That is:- Creat a query add a new column RecNo with this Code: RecNo: DCount("transid","feetable query","transid<" & [transid] & "AND STUDENTID=" & [STUDENTID])+1 and in the form in which i need the value place a unbound textbox with the code: dlookup("Recno","QueyName","transid="&[transid]). It Is working great.No Body Give this solution in this forum.????
Because it is similar to the approach used in Allen's link I provided you in post #3 (but potentially slower with large record sets because you are using dCount instead of Count in a totals subquery). but you ignored it....
Anyway looks like you learned something new and maybe next time a similar question comes in maybe you can jump in to help.
Cheers,