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 ]

Create a new calculation field "First_Letter" and set it to:

Left( Company_Name, 1 )

Then search on this new field.

Chuck

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

Chuck

Thanks for your input, your suggestion worked.