Recent content by utmigs

  1. U

    Can't figure out query with multiple filtering options

    I think that will work for what I'm doing. Thank you very much. That really helped me out. Again, I appreciate it.
  2. U

    Can't figure out query with multiple filtering options

    I tried both methods, and I couldn't get either one to return any records. Thank you both for taking the time though. I really, really appreciate it. It just seems like there should be some easier way to perform this type of query.
  3. 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...
  4. 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...
  5. U

    IIF function paired with Between...And

    That worked. Thanks a lot for your help. I really appreciate it.
  6. 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