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:
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)Code:SELECT Left$([keyword],3) AS expr1, Count (KeyWords) AS NumRows FROM tblKeyWords WHERE [KeyWords] Like "wis*" GROUP BY Left$([keyword],3);
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