What exactly does your sample query indicate? That is, what does he result mean?
Code:
SELECT tblStrings.[fldAccountNumber], tblStrings.[fldMRN], tblStrings.[fldPatientName], tblStrings.[fldArrivalDate], tblStrings.[fldStatedComplaint], tblStrings.[fldReasonForVisit], tblStrings.[fldPrimaryDx], tblStrings.[fldSecondaryDx], tblStrings.[fldTertiaryDx], tblStrings.[calcAllRFVFields]
FROM tblStrings
WHERE (((tblStrings.[calcAllRFVFields]) Like "*Thorax*" Or (tblStrings.[calcAllRFVFields]) Like "*Bite*" Or (tblStrings.[calcAllRFVFields]) Like "*MVC" Or (tblStrings.[calcAllRFVFields]) Like "MCC" Or (tblStrings.[calcAllRFVFields]) Like "*Assault*"));
MCC?
MVC ---motor vehicle collision?
I was hoping for some categorization of Injuries and some keywords/symptoms related to each.
There are some lists shown here that could be used to simplify overall processing. But it depends on what is really needed and what resources you (org needing the info) have for this project.
For example: If you had a table of injury types and for each injury type there was a predefined(at least partially) list of symptoms/description, then you could search for a number of these symptoms in the incoming data and assign a most likely injury. It would not be 100 % but would improve over time as words are added/removed/adjusted. You could even assign some weights to a particular patient visit based on the number of keywords found per injury type. In addition you could identify the part of the body affected and perhaps more words to focus the injury. Generally more categories and identifier/keywords within the category to refine the weight/diagnosis. Just some wild suggestions to help focus the issue your query and process is trying to solve and the eventual usage of the result.
Good luck with your project.