I have an access database that lists names. Also the names are seprated by slashes.
For Example
1st record, Mike Doe/Rob Doe/Jay Doe
Second Record, Jane Doe/Mark Doe
Third Record, Adam Doe
Is there a way to count those records so it says 6. I tried a number of ways, but i come up with 3.
Thanks for your help
For Example
1st record, Mike Doe/Rob Doe/Jay Doe
Second Record, Jane Doe/Mark Doe
Third Record, Adam Doe
Is there a way to count those records so it says 6. I tried a number of ways, but i come up with 3.
Thanks for your help