G
Guest
I have a database that is based on data from plays in a football game. There
is a form that I am trying to sort based off the values in a combo box. The
combo box looks up values from a table. The table is called tblcriteria and
has the criteria that meets certain situations. The form is run off a query
called qryloginformation
Following is some sample records from tblcriteria
tblcriteria
[name] [down] [distance] [yardline]
"3rd and Long" "3" ">10"
"3rd Down Long Backed up" "3" ">10" "<20"
the form frmlog has the following fields [down] [distance] [yardline] [play]
[result]
Is there an easy way to filter the information based off of this? As you can
see there are times when one or more of the criteria fields are blank.
is a form that I am trying to sort based off the values in a combo box. The
combo box looks up values from a table. The table is called tblcriteria and
has the criteria that meets certain situations. The form is run off a query
called qryloginformation
Following is some sample records from tblcriteria
tblcriteria
[name] [down] [distance] [yardline]
"3rd and Long" "3" ">10"
"3rd Down Long Backed up" "3" ">10" "<20"
the form frmlog has the following fields [down] [distance] [yardline] [play]
[result]
Is there an easy way to filter the information based off of this? As you can
see there are times when one or more of the criteria fields are blank.