Full Version: Row number on continuous forms
UtterAccess Forums > Microsoft® Access > Access Forms
TerryL
I have a form that display the top 20 records from an SQL view on to a continuous form. Is there any way that I can display the "ranking" on the current row for each record?
.g. The top record has 1, the next has 2 and so on down to 20?
I am thinking the only way is to have a form with 20 sets of controls and populate each one manually but that's a drag!
dashiellx2000
You might want to try looking at the AbsolutePosition function. I've never tried it myself, but it might work for you.
TH.
freakazeud
Hi,
check this sample!
HTH
Good luck
kuifjexx
Check this => Row Number
reetz from Belgium compute.gif
Luc aka Kuifjexx
TerryL
Thanx all - AbsolutePosition works a treat.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.