Solved One Or All Data If Null (1 Viewer)

[Hulk009]

Hello
I want to write criteria in the query that give me the result of a specified grade (1 - 2 - 3) when i select it from "Combo1" in the form "A" Or if i didn't choose any grade it will give me all the data.
I try this one but didn't get the result that i want:
[Forms]![A]![Combo1] Or Like ("*")

please i attached the Db so any help!

 

[ebs17]

WHERE
    Grade = Forms.A.Combo1
         OR
    Forms.A.Combo1 Is Null

The records displayed are those where the filter criterion evaluates to True.
I answer in SQL because a query is passed to the DB machine as SQL and executed there as such.

 

[Hulk009]

WHERE
    Grade = Forms.A.Combo1
         OR
    Forms.A.Combo1 Is Null

The records displayed are those where the filter criterion evaluates to True.
I answer in SQL because a query is passed to the DB machine as SQL and executed there as such.

i try it no result when Is Null because all data are not null so i wouldn't get all data like i want

 

[ebs17]

The error is not in the suggestion, but in your implementation.

 

[Minty]

Or politely, show us your query, because what Ebs suggested should definitely work.

 

[Hulk009]

maybe i didn't understand how to do it. can you try it on the database and attached it. PLEASE

 

[Hulk009]

Or politely, show us your query, because that what Ebs suggested should definitely work.

 

[bob fitz]

Ebs solution works. See attached file

 

[Hulk009]

Ebs solution works. See attached file

It works!! now I figure what he mean. Thank you for attaching file and the solution …. thanks "Ebs"