Newbies fbcenter53 Posted June 22, 2001 Newbies Share Posted June 22, 2001 In my database I want to search all records for the first letter in the first word of one field that contains company names, because right now if I serch for all company names that start with "A" I get all company names that have an "A" in their second or third word but not the first word of the comapny name. Is there a way of doing this? [ June 22, 2001: Message edited by: fbcenter53 ] Link to comment Share on other sites More sharing options...
Chuck Posted June 23, 2001 Share Posted June 23, 2001 Create a new calculation field "First_Letter" and set it to: Left( Company_Name, 1 ) Then search on this new field. Chuck Link to comment Share on other sites More sharing options...
JPaul Posted June 23, 2001 Share Posted June 23, 2001 quote: Originally posted by fbcenter53: In my database I want to search all records for the first letter in the first word of one field that contains company names, because right now if I serch for all company names that start with "A" I get all company names that have an "A" in their second or third word but not the first word of the comapny name. Is there a way of doing this? [ June 22, 2001: Message edited by: fbcenter53 ] I have just replied to your other message yesterday; if tou have seen it then apply it: it works. Regards Link to comment Share on other sites More sharing options...
Newbies fbcenter53 Posted June 24, 2001 Author Newbies Share Posted June 24, 2001 Chuck Thanks for your input, your suggestion worked. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8341 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now