select field which contains certain text
- From: "Russ" <Russ@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 09:47:13 -0700
Hi,
I have a query which looks into a table called ROS/PMH_Diagnosis for data in
a field called Diagnosis. I want to return the text if it contains the
desired value. it is also filtered by social security number so only the
diagnosis for a particular patient will be returned. i use this DLookup
function:
Diabetes: DLookUp("[Diagnosis]","ROS/PMH_Diagnosis","[SSN]=" & "'" & [SSN] &
"'" & " AND [Diagnosis]=" & "'Diabetes mellitus Insulin dependant'" & "")
I want to work diabetes to come back if the diagnosis is Diabetes. Here is
my problem, i have several different types of diabetes diagnosis, ie.
Diabetes mellitus Insulin dependant, diabetes mellitus non-insulin dependant,
diabetes mellitus with osteomyleteis, etc etc etc.
how do i change this lookup to find all that contain "Diabetes mellitus"?
thank you very much
russ
--
Russ
.
- Follow-Ups:
- RE: select field which contains certain text
- From: Chaim
- RE: select field which contains certain text
- From: Chaim
- RE: select field which contains certain text
- Prev by Date: Re: Need Between not UpTo (not including)
- Next by Date: Re: The like clause of sql
- Previous by thread: Need Between not UpTo (not including)
- Next by thread: RE: select field which contains certain text
- Index(es):
Relevant Pages
|
