I need it to be a text field because we sometimes have evidence items that need to be listed as 1A.
Is there any other suggestions.
Thank you so much for your help again. You helped me yesterday.
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.
My I have my report right now showing the below:
Insured Name:
Insured Company:
(There are 2 seperate fields in my report)
The majority of the time I have an Insured Name. There is a few circumstances where I don't have an insured name, I have a insured company name. I would like to just...
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])