Indicating if a record is in two tables

[CRAMan]

Ok, I am trying to do a report with three tables. I need all the records from table A, I also have need two yes/no indicators to show if an item with a record in table A also has records in tables B & C.

I tried to do a formula:
if ISNULL (key.b) then
"No"
Else
"Yes"

The results of this is ONLY records that only have records in both and and B (all yes)

Any help?

 

[Ngolem]

Are you left outter joined on {key.b} between the two tables???

if so then the formula is

if not isnull({key.b}) then
"yes"
else
"no"; Jim
JimBroadbent@Hotmail.com