That test should be helpful. The RoomMate is always listed by LastName, FirstName right? If no roommate then the field is = to "0" or is it simply = ""?
Administrator
Windows 10 
Access 2013 32bit
That test should be helpful. The RoomMate is always listed by LastName, FirstName right? If no roommate then the field is = to "0" or is it simply = ""?
Novice
Windows Vista Access 2007
It's = to "0" (I took out people without roommates for that stripped down database I attached to the last message for simplicity's sake.)
Originally Posted by RuralGuy
Posting Permissions
Reply With Quote