Quote Originally Posted by salman afzal View Post
The issue is with iCount > 5 , I just need to understand how can I get it to show if the sLT is less than 5 and if its over 5 than limits to show 5 names as maximum
read your statement out loud...

DO while NOT EOF and icount GREATER than 5..... erm... two choises here... not EOF as first and greater than 5 as second...

you want : DO while NOT EOF and NOT icount GREATER than 5

all your really missing is the brackets...

Code:
Do While Not (rsP.EOF And iCount > 5)