I would like to create a form that includes all the variables in my dataset, in which I can select a certain value, or a range of certain values for any amount of variables in one of tables and based on the values I put in the form, it will generate a query.
For example, Lets say my table had four variables
Face Amount AGE Life Expectency Policy Loan
In the form I would like to specify.....let s say.....
Face Amount 100,000-1000000
AGE 70-85
Life Expectency 60-100
Policy Loan (nothing) I want to just leave it blank and thus no criteria will be selected
For example, Lets say my table had four variables
Face Amount AGE Life Expectency Policy Loan
In the form I would like to specify.....let s say.....
Face Amount 100,000-1000000
AGE 70-85
Life Expectency 60-100
Policy Loan (nothing) I want to just leave it blank and thus no criteria will be selected
Comment