I wanted to use IIf function Iif(IsNull([EVF Date]),1,[EVF date]) I also tried using Iif([EVF Date]=" ",1,[EVF Date]) but I get =Error on both expressions when Im running the report. All I want was to put the value 1 when my field is blank (EVF Date is in medium date format) so that i can count the number of blank fields later on which im still figuring out how to if I will place it on the rightmost part of my report(same row). Could anyone please help me with this? I need your prompt reply PLEASE...