Criteria in a query

[Lorena]

Hi

I have a query designed to list all the names and phone
numbers of business associates. under the criteria section
in design view, I have it saying [Enter name]. But if the
person does not know how to spell the name correctly, how
can I make it so that the criteria field will accept only
the first few letters and match it to the columns?

Does this make sense? I'm completely new to access.

Thanks in advance.

 

[Lynn Trapp]

Put this in the Criteria instead:

Like [Enter Name] & "*"

That will pull all records in the table that have the combination of letters
at the beginning of the name.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Kelvin]

To make sure that only certain names are allowed, you will have to set this
up as a form using a combo box instead of the default criteria windows.
Then by setting the LimitToList property of the box to Yes, only names in
the table will show up. Then you will have to add code to call up the query
using this combo box. Let me know if you want to try this.

Kelvin

 

[Joe Laco]

Lorena,

Like [Enter Name] & "*"

Copy the above line into the criteria field. This
should work, let me know if you have any problems.

Joe