Report-Extra Critera Help

[brinkerdana]

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

[JohnGage]

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.

[brinkerdana]

Thanks!

Since the space is on the customer page, you'd think it would be included in the standard criteria.