Search the Community
Showing results for tags 'blank'.
Hi there, Could anyone help me to resolve the issue with the following search logic scenario: a user can search by Date field with "from&to" range with criteria, but if criteria are blank I would like to return records with blank Date field Field datetype: Date&Time Thanks, @Vitalikssssss
I have a search form where I'm using a range comparison type to find items within certain ranges. My data contains numbers but also blank cells. While still using range comparison type, is there a way to search for and return results where value is blank or NULL?
I recently created a relatively simple database of names and locations. I have noticed that if you leave the fields blank and hit the search button, the entire database displays, which is not desirable. As far as I can tell, the only way to prevent this is to put minimum character requirements in the fields. This is okay but I was wondering if there's another solution I overlooked. Thanks for your help!
I have a report data page that lists all customers and purchase orders through a left outer join view that shows ALL Customers and Purchase Orders, regardless of the whether the PONum field is blank or contains a PO Number. How can I label the blank fields to show something like "No Orders " instead of a blank field. All suggestions are greatly appreciated.