Hello,
I have a form with drop down menus that I use to run a query. On the form I have 4 different drop down menus. I am wondering if there is a way to refine the query if more menus are filled in but if one is left blank then the query will still work. Right now the only way I have figured out how to make the query work is if everything is an "or" statement and only one menu can be filled out at a time. I have so many records that I need a better way to run queries so the record I am searching for can be found with ease. Thanks for any help.
I have a form with drop down menus that I use to run a query. On the form I have 4 different drop down menus. I am wondering if there is a way to refine the query if more menus are filled in but if one is left blank then the query will still work. Right now the only way I have figured out how to make the query work is if everything is an "or" statement and only one menu can be filled out at a time. I have so many records that I need a better way to run queries so the record I am searching for can be found with ease. Thanks for any help.
Query from a Form
0 commentaires:
Enregistrer un commentaire