>No, they are suppose to be numeric fields, but dependant on date fields for output... like this....
>
>Here is the SQL
>

>SELECT	ALL;
>        PADR(FRMAST. CUSTNO + " " + LKUP("MFCUST","CUSTNO",FRMAST.CUSTNO,"CUSTNAME", "","","","MFCUST"),30) AS FRCUSTNONAME,;
>        FRMAST.REVCODE                 AS FRREVCODE,;
>        FRMAST.INVNO                   AS FRINVNO,;
>        IIF(BETWEEN(transdate,DATE()-30,DATE()),FRMAST.BALDUE,0) AS BAL30,;
>        IIF(BETWEEN(transdate,DATE()-60,DATE()-31),FRMAST.BALDUE,0) AS BAGE60,;
>        IIF(BETWEEN(transdate,DATE()-90,DATE()-61),FRMAST.BALDUE,0) AS BAGE90,;
>        IIF(transdate <DATE()-90,FRMAST.BALDUE,0) AS BAGE90P,;
&gt;        FRMAST.TOTCHGS                 AS FRTOTCHGS,;
&gt;        FRMAST.BALDUE                  AS FRBALDUE;
&gt;  FROM	"FRMAST" FRMAST;
&gt;  INTO	CURSOR AGINGDET;
&gt;  WHERE	(FRMAST.BALDUE>=0.01);
>  ORDER BY	1, 2
>

>

If you put BROWSE NORMAL after this SELECT what are the values in these fields?