GKatReliable
Programmer
I am struggling a bit with a line of code I have to modify in a program that generates Cobra letters from an HR system that I support.
I have a series of logical fields in my work database that say which benefit they have for which a letter should be printed. One of them is just plain "Medical". The system change presented to me is a new letter for an HMO in Illinois, so I have a logical field for "Hmoil".
I am counting for Medical=.T. to see if there are any to print this week, but now the people who are .T. for Hmoil should not get the Medical letter, they get their own. My count has to pull in .T. for Medical but exclude .T. for Hmoil. The premise is that earlier in the program and for other reasons, these HMO people are marked .T. for medical to begin with.
If I say:
COUNT TO mcount FOR medical .AND. .NOT. hmoil
then to me this implies it is looking for hmoil = .F., which is not what I want. I am hung up in counting for medical=.T. and exclude hmoil also being true, and the syntax is killing me.
Regards,
Glenn Koproske
I have a series of logical fields in my work database that say which benefit they have for which a letter should be printed. One of them is just plain "Medical". The system change presented to me is a new letter for an HMO in Illinois, so I have a logical field for "Hmoil".
I am counting for Medical=.T. to see if there are any to print this week, but now the people who are .T. for Hmoil should not get the Medical letter, they get their own. My count has to pull in .T. for Medical but exclude .T. for Hmoil. The premise is that earlier in the program and for other reasons, these HMO people are marked .T. for medical to begin with.
If I say:
COUNT TO mcount FOR medical .AND. .NOT. hmoil
then to me this implies it is looking for hmoil = .F., which is not what I want. I am hung up in counting for medical=.T. and exclude hmoil also being true, and the syntax is killing me.
Regards,
Glenn Koproske