Search results

I have a form that lists evidence items 1, 2, 3, ect.... The form is listing them 1, 10, 11, 12, 13, 2, 3, 4, 5... I have tried right clicking the evidence item # field and doing a sort a to z, and it is still listing them the wrong way.

I have a report that I am trying to make it list an insuredName, and if I don't have insured name it would input a insuredCompany name. This is what I have. What is wrong? HELP =IIf(IsNull([insuredname]),[insuredCompany] & " " & [insuredName])