Muffinshuttleworth
New member
- Local time
- Today, 14:38
- Joined
- Aug 13, 2009
- Messages
- 5
I have a master table which contains all our clients' details. I am running a query to pull out specific health problems from the field named healthnotes. In this field are ALL medical and health issues pertaining to the client e.g. depression, osteoartritis, suffered stroke etc etc. I can run the query fine but it i only pulling out those clients which ailment is at the beginning of the field. E.G. Mrs Smith has depression, diabetes and had a heart attack. If I run the query to pull out clients with diabetes, Mrs Smith would not appear as 'diabetes' is the second entry in ther healthnotes field. She would however appear in the clients with depression query as that's first entry in the field. I have tried wildcards, and letter specific criteria and nothing seems to pull out any value further along the field. HELP PLEASE!!!