brucesilvers
Registered User.
- Local time
- Today, 11:57
- Joined
- Aug 4, 2000
- Messages
- 70
Problem: Need to compare one table's MemberName (single text field) that contains first and last name together (eg. Boris Badanoff) with another table's MemberName that contains only first name (eg. Boris). Names in 1st table are separated by a space. All first names in both tables are unique and length of first name varies.
Is there an Access function I could use in the Expression Builder to capture the first names only from the 1st table? If not, is there simple code I could call from a query to do so?
Thanks in advance for any help you can provide!
Is there an Access function I could use in the Expression Builder to capture the first names only from the 1st table? If not, is there simple code I could call from a query to do so?
Thanks in advance for any help you can provide!