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