I need to run a query, in which the user inputs a string, and then the query returns any records, in which any part of the data matches a string. For example, the parameter "w" would return "wa", "ew", etc. I can do this easily enough:
SELECT getSourceID.Title, getSourceID.Author, word.form, word.gloss, word.pageNumber, getSourceID.Publication FROM getSourceID INNER JOIN word ON getSourceID.[ID] = word.[source] WHERE (((word.form) LIKE "*" & Forms!FsearchByForm!contains & "*") AND ((getSourceID.Publication) Between Forms!FsearchByForm!minYear And Forms!FsearchByForm!maxYear));
But alas my SQL isn't very good. I need to extend this so that V and C can represent a vowel or consonant respectively, i.e. a parameter "Vw" would return any instances in which the record contained "aw", "ow", etc.
Is there a way of implementing this into a