How to use if in query critera

[ali_sh]

Hello
I believe it's simple question but I'm inexperienced in Access so I'll be grateful if you help me on this.
I created a table:

and a simple query to find what I want:

but it doesn't work when I enter "b" or anything but "a" ([Table1]![Field1]>2 part doesn't work.)
How can I write a code for this?


thanks in advance

[JoeM]

I want to understand better what you are trying to do and why, but I fear that you may have oversimplified things a bit, making it hard to see.
I have a feeling that the answer to your question is to do it another way, but without having that full understanding, I am not sure what you recommend.

Can you provide a more realistic example, and explain exactly what it is that you are trying to do?

[ali_sh]

I want to understand better what you are trying to do and why, but I fear that you may have oversimplified things a bit, making it hard to see.
I have a feeling that the answer to your question is to do it another way, but without having that full understanding, I am not sure what you recommend.

Can you provide a more realistic example, and explain exactly what it is that you are trying to do?

Thank you for your answer
I have a search form containing a combox with all/yes/no option.
If user select yes, zero value of a column of table and if select no, other value of that column, and if select "all", all of them with search query should return.
My actual problem is very similar to what I described before and I,m very curious to understand what's wrong with my written code, so if you tell me which part of the code is wrong I would be able to sovle my problam

[JoeM]

I have never seen it attempted to be done that way. What I have typically done in the past is to create a Form where the user can select query criteria "on-the-fly", and then have VBA to build the SQL code for the query behind the scenes, apply it to my query, and then open the query.

Kind of like what I did here: https://www.accessforums.net/showthr...587#post435587

[Micron]

remove the greater than 2 part (>2) and see what you get. It doesn't make sense.
EDIT - the approach sort of doesn't either. Why not just have the criteria refer to the combo and make use of what's been selected? There are pitfalls to referring to form controls (e.g. the form has to be open, query will still run if no data is in the control, etc.) but it's not a bad way to learn. Sql in vba should be the end goal of your learning curve on this part of the project but it can be challenging if you have little experience with it.

[davegri]

[Table1]![Field1]>2 is an expression that will return either TRUE or FALSE. Probably not what you want.