Recent content by jufg

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...

Thanks for the advice plog and Ranman. If I were to use the code you have provided Ranman, how would I actually go about getting it to work?! Sorry guys I'm a beginner with Access and have been trying to pick it up myself through bits and bobs online, hence the lack of best practice!!

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...