Access query criteria from check box in from

Please help me to solve the below query criteria based on a checkbox in the form.

IIf([Forms]![TYPEBRANDLOCATION-MAINFORM]![CHKAGE4plus]= True,>=4,>=0)

The result returns only the value with 0.

Please help to solve this.

Solution

You could use this expression:

>=IIf([Forms]![TYPEBRANDLOCATION-MAINFORM]![CHKAGE4plus],4,0)

SQL want to calculate time hours and mints of each emp
How to make multiple select into on the same table?
Invoking a stored procedure with all combinations of values stored in multiple single-column tables
Get Value From Json object contain table column using SQL Query
Hackerrank Winners chart SQL advance level question
How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
How do I retrieve SQLite engine introspection information via Rust SQLx?
How can I add machines to data already been sharded in SQL database?
Doing a WHERE IN on multiple columns in Postgresql
Is there any better option to apply pagination without applying OFFSET in SQL Server?
What is the most suitable data type for a column in a table?
Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
How to select non-integers (varchars) that possibly have leading zeros?
PHP mysql table for comments
String interpolation inside a formattable string in C#
SQL - How to insert unique id in XML tag
What represents a double in sql server?
sql select query name -value pair
What difference does WITH GRANT OPTION make?
Replace null with 0 in MySQL
What does # mean in SQL?
Renaming foreign-key columns in MySQL
The named 'CommandType' does not exist in the current context
Build SQL queries in Python
Insert multiple rows in ORACLE by referring 2 tables
How can I work with SQL NULL values and JSON in a good way?
Incorrect syntax near ''
Extract epoch from column of timestamps in Postgres
SQL - insert rows preserving overall number of duplicate values
Columns to rows in one scan and one query