Hi,
I have a list of Equipment IDs that I enter into my selection criteria.
If an Equipment ID is not in the database, it doesn't show up on the report. What formula would I use to display the Equipment ID number(s) that are not in the database as well as a statement beside them saying "No Data Found"?
Thanks for your help!
I have a list of Equipment IDs that I enter into my selection criteria.
If an Equipment ID is not in the database, it doesn't show up on the report. What formula would I use to display the Equipment ID number(s) that are not in the database as well as a statement beside them saying "No Data Found"?
Thanks for your help!