G
Guest
I have designed a select query to list staff details in a form. I am entering
the criteria for the query via a form with unbound controls (5 different
criteria). I want the option to select values for less than the 5 criteria,
leaving 1 or more of the unbound controls blank and eliminate these fields as
criteria for the returned records. So i have for example two criteria, one
for the town where staff are located, and one for gender - i want to look at
male staff in all towns - however if i leave the "town" control blank, i get
no records returned by the query.
the criteria for the query via a form with unbound controls (5 different
criteria). I want the option to select values for less than the 5 criteria,
leaving 1 or more of the unbound controls blank and eliminate these fields as
criteria for the returned records. So i have for example two criteria, one
for the town where staff are located, and one for gender - i want to look at
male staff in all towns - however if i leave the "town" control blank, i get
no records returned by the query.