So i have several criteria in my query. the criteria take parameters which are indicated using a drop down in an excess cell.
I would like it so that if the cell is blank, that the criteria not be filtered and all items are returned.
Example in my SQL command
SELECT....
FROM.. "repair_tech"."surname" = ?
The variable is the tech's surname. I want the table to display all results if no surname is specified.
thanks
Maya
Bookmarks