Query that outputs a list when only first letter is given.

[MZ^]

Hi,
I have just spent an hour trying to figure out how to create a query that will output me a list of results just by typing in the first letter at the prompt.
For example, I have a list of 200 companies stored in my database; I want the query to display all the companies that start with the letter "C". How can I create such a query?

Please help me.

 

[Rob.Mills]

Do you want to setup the query to prompt you for this info?

If so, include your criteria.

 

[MZ^]

Yes, I would like the query to prompt for the first letter. The criteria would be [Type in the first letter of the Company's name] .

Thanks for replying.

 

[shay]

Hi

In the Company criteria box of your query put

Like ([Type in the first letter of the Company's name] & "*")

hth

shay

 

[MZ^]

shay, thanks for your reply, but when I entered the criteria you gave me - when the query is run, I type in the first letter at the prompt but it displays me an empty table, even though I have filled in the Company table.
Any ideas why that happened?

 

[MZ^]

Ah got it! missed the 'Like' bit.

Thanks again shay!