Search results

  1. J

    Query Problem on multiple criteria search

    Hi all, I'm back working on my multi-search form for users, where the user can enter in details and also have the ability to search between dates and numerical values. The problem, is that the query is too complex. When I run the query with just the text searches it works fine, the issue arises...
  2. J

    Using IIF statements in queries

    Hi all, fairly new to access and I'm trying to create a 'Search' form. The form enables people to search a combination of 20 different criteria. I have been able to get the 'text' searches to work and am using the following in the criteria section for each text field searchable: Is Null Or...
Top Bottom