Count number of records starting with specific characters

[Khalil Handal]

Hi to all,
I am trying to count number of records in table tblKeyWords with two fields only: (pkKeyWords, KeyWords) starting with three specific alphabets, say wis as an example.

I have records like:
Wisdom
Wise

I have the following code:

SELECT Left$([keyword],3) AS expr1, Count (KeyWords) AS NumRows FROM  tblKeyWords WHERE [KeyWords] Like "wis*" GROUP BY  Left$([keyword],3);

Running the query asks for Parameter Value and it takes the first three letters. If I type wiso the result is: wis 12 (meaning that I have 12 records starting with the letters wis)



Is it possible to replace the (Like "wis*") with the Parameter Value ?
If I type summary it takes the letters sum as the like part of the criteria.

Khalil

[Minty]

The query as shown wouldn't ask for a parameter?
If it does you have specified one but aren't using it.

Try this

SELECT Left$([keyword],3) AS Matches, Count (KeyWords) AS NumRows FROM  tblKeyWords WHERE [KeyWords] Like [Enter Search Letters] & "*" GROUP BY  Left$([keyword],3);

[Khalil Handal]

Hi,
Thank you for the reply.
The query I have do ask for a parameter but I am not able to use that parameter. I want to use the first 3 letters of the parameter I type.
Thanks.

[Khalil Handal]

Hi,
I got what I needed with the following code:

SELECT Left$([keyword],3) AS Matches, Count (KeyWords) AS NumRows FROM  tblKeyWords WHERE [KeyWords] Like (Left$([keyword],3)) & "*" GROUP BY  Left$([keyword],3);

Thank you
Khalil

[Minty]

Sorry your use of Keyword as the parameter and Keywords as the field name confused me- I didn't spot the subtle difference in it until your reply.