Sorting results in runtime
Hi all,
I have a database search engine (Driven from MS Access) .. I need to sort the results depending on the number of occurances of the keyword used for search.
For example if I search for: "business money" I get results sorted from the record the have the most occurances of "business" and "money" (or for now just one of them).
One simple idea maybe creating a temp table in my database and then putting all the results and the number of occurances and then sorting it.
But i need help doing this,
Thanks very much,
zeid