Hi Good day to all,
i sorted the P_Date in descending (thru Query1) and provided the result correctly.
However, I prefer that the Blank row in RED (with default value of Date today on D_Data) should be on the top.
I tried the option MySort: IIF(IsNull([P_Date],999999,[P_Date]) but does not work.
Can you please help me to formulate my required output (attached is the sample databse)
Thank you
i sorted the P_Date in descending (thru Query1) and provided the result correctly.
However, I prefer that the Blank row in RED (with default value of Date today on D_Data) should be on the top.
I tried the option MySort: IIF(IsNull([P_Date],999999,[P_Date]) but does not work.
Can you please help me to formulate my required output (attached is the sample databse)
Thank you