Do you have a SET RELATION between the dtr and upcode tables?? If not, how are you forcing the upcode table to be on the correct record for each dtr record.
Cathy
>i have a problem,
>
>i have 2 tables: dtr and upcode, both have upcode fields. in DE i drag upcode's upcode to dtr's upcode to get desc field of upcode.
>
>in my report, i have a list of days for a certain month. i want to display the description if dtr's upcode is not empty, so i have
>
>IIF(dtr.upcode=" ","",ALLTRIM(upcode.desc))
>
>it should simply display the desc field. in my report day 1, upcode="V", so it display's "VACATION LEAVE".
>
>on day 2, upcode="H", but it does not display "HOLIDAY".
>
>in my upcode table i have H = HOLIDAY.
>
>i suspect that the error is probably caused the word "desc" i used in my upcode table, so i changed it to "descri", i rebuild my project and run the report.
>
>but it's still giving me the same error.
>
>what could possibly be wrong?