I have a table which contains a memo field that holds a series of keywords seperated by a space, eg "egg apple orange", and I need a query that will count how many times a keyword appears in the records.
The database is a store of personal details and the field in question contains disability...