Display text based on If statement 1

[Bronte1226]

I need to create a query where the value for a field is "on file" if the underlying field in a table is not null and blank (the actual value of the field) if it is null. How do I go about this?

 

[PHV]

NewValue: IIf([underlaying field] Is Null, Null, 'on file')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bronte1226]

Thanks so much PH, that worked perfectly!