IIf within Query - problem

[papasmurfuo9]

Hi

in my query i have multiple tables,

one table just has one field called product thats joined to another table

the other table displays a list of all products, if the product is in the other table
i want a "X" to display in that field

both columns are text

the IF im using is,

IIf([Product] Is Null,"","X")

but when i run this, it displays no records what so ever,
if i take out that iff, it displays all records i want, but that field is the product number when i need an X

thank you

 

[namliam]

Are you putting that in the criteria line? that is the only reason there should be no records

Other than that the IIF should be valid?

 

[papasmurfuo9]

Hi Yes in the criteria line

 

[papasmurfuo9]

got you, put it in the field line and it works, thanks :}

Product : IIf([Tbl_MMP]![Product] Is Null,"","X")

 

[namliam]

Dont put it in the criteria line then, but in the select line / field line / top line