Ucase() function question

[pm709]

Hi:

First of all; let me say it: You guys are the Best!

OK, this is (I guess) a simple question:
I have a field in a query: F14: IIf([F4] Is Not Null,[F4],"MISCELLANEOUS"). This statement inserts the word "Miscellaneous" in field [F14] if field [F4] has a blank (empty) record. But I want to convert the text in [F4] to Uppercase too. I've tried using Ucase() statement, but I don't know how to put them together. Any suggestion?. Thanks in advance.

 

[shaggy]

F14: IIf([F4] Is Not Null,UCase([F4]),"MISCELLANEOUS")

 

[pm709]

Wow! Fast response, Thanks.