>I have 2 tables; the first table is employee table, and the second table has a General field which holds photo. I want to run a report. I decided to join the tables using left join because there isn't always an entry in the photo table to match with the employee table. Where there isn't an entry in the photo table, it shows a .Null. value in the field. My problem is every time I hit a record .Null. value, I get an error "FIELD MUST BE A GENERAL FIELD" in the report. I tried several ways to get around this. Print when photo<>.NULL. Another way Print when type('photo')="G".
>
>Does anyone have any suggestions?
>
>TIA
>Jim
Try Print when NOT ISNULL(photo)
--sb--