Recent content by ewarthur

Hello again, I did a google search on "text analysis with Microsoft Access" and found a great Access database which has solved my problem. Please see: funsci.com/fun3_en/lexicon/handbook.htm for a downloadable database and description of how this works. Thanks to all for your advice...

Unfortunately I don't know how to get 2 or 3 word phrases. Does anyone know how I could do this in SQL?

Hello again Pat, I found this code below which has helped. I can run through each word and add this to a table. I will then need to work out how I can grab 1 or 2 words from the keyword I have identified to make up a 3 word phrase. Thanks again. Function SelectWords(InString As String...

Hello Pat, Thanks for replying. I'm not sure where to start with VBA, especially if the VBA code cannot be called from a query.

Hello, I have a database in Access 2007 which contains a field called PO Line Item data. I am looking to identify which are the most frequent words and phrases (perhaps up to 4 or 5 words in length) as well as a frequency count. I would like access to create another table to record this...