C
Chuck W
Hello,
I have a field in a patient table called PrimaryDiagnosisCode which has a
five character value that is either numeric or alpha numeric. I also have a
field called AllSecondaryDiagCodes which has these same five character values
but can have several of them all separated by semi-colons. For instance, a
value can look like the following:
;25002;99760;4439;2809;V5867;V6284;412;496;41400;2
I have been given a list of codes to find in either field (Primary or
secondary) along with exception codes for the secondary. For instance, if
the code 64880 appears in the secondary code, then I need to excldue it from
my query results. I am trying to figure out using the Design view grid what
to put in the criteria statement. For instance, If I am looking for codes
*;25000;* or *;25001;* or *;25002;* in my primary or secondary field but want
to exclude *;64880;* or 79029;* or *;77510;* in the secondary only how would
I do this?
Thanks,
I have a field in a patient table called PrimaryDiagnosisCode which has a
five character value that is either numeric or alpha numeric. I also have a
field called AllSecondaryDiagCodes which has these same five character values
but can have several of them all separated by semi-colons. For instance, a
value can look like the following:
;25002;99760;4439;2809;V5867;V6284;412;496;41400;2
I have been given a list of codes to find in either field (Primary or
secondary) along with exception codes for the secondary. For instance, if
the code 64880 appears in the secondary code, then I need to excldue it from
my query results. I am trying to figure out using the Design view grid what
to put in the criteria statement. For instance, If I am looking for codes
*;25000;* or *;25001;* or *;25002;* in my primary or secondary field but want
to exclude *;64880;* or 79029;* or *;77510;* in the secondary only how would
I do this?
Thanks,