I need to run a list of customers excluding inactive accounts. There are 2 codes for inactive accounts, so the report would need to exclude IA & IN.
The field doesn't appear to be available in the standard critera list.
Thanks.
Dana
Making the field available would be too easy.
SUBSTR(ins.c,3,2)<>"IA" AND SUBSTR(ins.c,3,2)<>"IN"
The code says go to the C field in ins.dbf. Then go to the 3rd character in the field and then evaluate characters 3 & 4 for the specific codes you need to look at.
Thanks!
Since the space is on the customer page, you'd think it would be included in the standard criteria.