bfuchs
asked on
#Type! error in report
Hi Experts,
Any idea why the following works
And the following gives me a #Type! error?
Thanks
Any idea why the following works
=IIf([Shift_From_Hour]=[SFH] And [Shift_From_Minute]=[SFM] And [Shift_From_AMPM]=Nz([SFAM],""),"",[SFH] & ":" & Format([SFM],"00") & " " & [SFAM])
And the following gives me a #Type! error?
=IIf([Shift_From_Hour]=[SFH] And [Shift_From_Minute]=[SFM] And [Shift_From_AMPM]=Nz([SFAM],[Shift_From_AMPM]),"",[SFH] & ":" & Format([SFM],"00") & " " & [SFAM])
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could apply the NZ() function to this field reference.
ASKER
Actually this works
[Shift_From_AMPM] & ""
Thank you!
[Shift_From_AMPM] & ""
Thank you!
ASKER
So what do you suggest?
Thanks,
Ben