Romio_1968
Member
- Local time
- Today, 15:57
- Joined
- Jan 11, 2023
- Messages
- 126
I have a string Query field with the following structure
;1;14;8;17;62;
So they are numbers that are allways sided by semicolons
The field will contain at least one number ;n;
I need a criteria that based on a control value to return all the records for the case control is Null or empty, or the record containin ";x;", for the case the control is filled.
I tried
Like (IIf(IsNull([Forms]![SearchTitle_Frm]![Inventory_No]) Or [Forms]![SearchTitle_Frm]![Inventory_No], "*", ";" & [Forms]![SearchTitle_Frm]![Inventory_No]) &";")
Works good for the numerical values, but fails to return all records in case of null or empty
What am I doin wrong?
Thank You
;1;14;8;17;62;
So they are numbers that are allways sided by semicolons
The field will contain at least one number ;n;
I need a criteria that based on a control value to return all the records for the case control is Null or empty, or the record containin ";x;", for the case the control is filled.
I tried
Like (IIf(IsNull([Forms]![SearchTitle_Frm]![Inventory_No]) Or [Forms]![SearchTitle_Frm]![Inventory_No], "*", ";" & [Forms]![SearchTitle_Frm]![Inventory_No]) &";")
Works good for the numerical values, but fails to return all records in case of null or empty
What am I doin wrong?
Thank You