This field name is not known when 0 record

[Gus01]

Hello,

I have a report with 2 tables :
Ta --> fields (ANNEE, Fa1, Fa2)
Tb --> fields (ANNEE, Fb1, Fb2)

Link = Ta.ANNEE --> tb.ANNEE Left Outer Join

and this formula for knowing if there is 0 record in table Tb :

If IsNull({Tb.ANNEE}) Then
0
Else
{Tb.ANNEE}

But when there is no record in table Tb, I receive :
'This field name is not known'

How can I know when there is 0 record in table Tb ?

Thank you.

 

[dgillz]

Did you manually type the field name or did you get it by double clicking it from a list of field names? I would try the latter.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Gus01]

I get it by double clicking it from a list of field names, and the report is shown when there are rows in the table Tb.
But sorry, I found the problem in the program, outside the report.
There is effectively no columns (no fields) in the table Tb, when the table is empty, so that's why the field name is not known ...

Thank you for your help.