#ERROR Message

[Guest]

I have code in a report text box that works great.
Just one problem, If the field or fields is missing or doesn't have data the
function will display and annoying "#Error" message. How can I just display a
blank or "N/A" Message instead. Thanks all

diff2dates("hn",CDate([rec Dte] & " " & [rec time]),CDate(Date() & " " &
Time()))

 

[John Spencer]

Test to see if the field or fields is null

IIF(IsNull([Rec Dte]),"N/A", diff2dates("hn",CDate([rec Dte] & " " & [rec
time]),CDate(Date() & " " & Time())))

If you need to check both then
IIF(IsNull([Rec Dte]) or IsNull([rec time]), ...,...)

 

[Guest]

This works fine if Rec dte or Rec dte are blank, but #Error appears if no
records meet the query. How do I control the message when no records are
found for this query in the report? Thanks for your help Mr. Spencer

Test to see if the field or fields is null

IIF(IsNull([Rec Dte]),"N/A", diff2dates("hn",CDate([rec Dte] & " " & [rec
time]),CDate(Date() & " " & Time())))

If you need to check both then
IIF(IsNull([Rec Dte]) or IsNull([rec time]), ...,...)

I have code in a report text box that works great.
Just one problem, If the field or fields is missing or doesn't have data
the
function will display and annoying "#Error" message. How can I just
display a
blank or "N/A" Message instead. Thanks all

diff2dates("hn",CDate([rec Dte] & " " & [rec time]),CDate(Date() & " " &
Time()))