Spork, I had thought of that already, but I was not given any control over the data pulled from the database in the Recordset. That was handled by someone else.
I did have the if...then statement on one line, but that doesn't mean I didn't do something else dumb. I didn't say your's wouldn't work, just that I wasn't able to get it to before I got the other solution to work. I do appreciate the help from both of you!
Hi, I haven't programmed in a LONG time and am having trouble figuring out how to code the comparison criteria for looking for a range of last names in a Recordset. This is what I want to do:
While Not EOF
If Name Field Begins with A thru M Then
Do Action
Move to Next Record
End While
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.