Search results

  1. U

    Can't figure out query with multiple filtering options

    I have a query that involves nearly 10 fields. I have a form that I use to input criteria for the query. My problem is that when I enter criteria for multiple fields, I get more records than what I ask for. For instance, if I ask for all Buildings that have Street Numbers between 2000 and...
  2. U

    Text box value is null unless corresponding check box is checked

    I'm trying to make a form that provides criteria for a query. There are 5 items listed that the user can search with. I want the user to be able to check the items they would like to search with, then type in the criteria. I was wondering if there was a way to only allow a value in the...
  3. U

    IIF function paired with Between...And

    I am trying to build a query that will display certain filtered data from a table. I only want the query to pick up items for filtering that are checked by a corresponding check box. I also need to use a range of values as query criteria. For example: I have a field named "Price". The query...
Back
Top Bottom