Firstly, I know, I know, I don't like Access much either. It is what I have to use and support at work until I can manage to get a proper database. I will probably still use Access for a frontend though because it's already standard on all of our computers....anyway.
I am trying to build an SQL query that uses parameters from a form. I know that this is possible because I did this on a practice database today.
It is a bit daunting because there are over 10 fields/parameters that the query needs to handle. It also needs to be able to handle null fields, because the user will not always use every field during a search.
The problem is that the parameters in the fields do not appear to be affecting the query at all, even though everything is pointed to correctly in the SQL query.
I'm not at work, so I can't just copy and paste the query, but I can tell you that I am using all OR statements. This is because I do not want one parameter to be dependent on another parameter in any way. It simply needs to filter out data from the table based on the query and display it.
So, does anybody here with experience in this sort of thing have any insight into what I can check? I'm a bit perplexed, because I have an identitical, but much smaller, query working perfectly in another database.
I am trying to build an SQL query that uses parameters from a form. I know that this is possible because I did this on a practice database today.
It is a bit daunting because there are over 10 fields/parameters that the query needs to handle. It also needs to be able to handle null fields, because the user will not always use every field during a search.
The problem is that the parameters in the fields do not appear to be affecting the query at all, even though everything is pointed to correctly in the SQL query.
I'm not at work, so I can't just copy and paste the query, but I can tell you that I am using all OR statements. This is because I do not want one parameter to be dependent on another parameter in any way. It simply needs to filter out data from the table based on the query and display it.
So, does anybody here with experience in this sort of thing have any insight into what I can check? I'm a bit perplexed, because I have an identitical, but much smaller, query working perfectly in another database.