MS Access - SQL exclude data query

Question

Original question was unclear, so attempting to simplify and rephrase.

In MS Access I have a Query that is supposed to find all records which:

1. Have a PhaseID (entered by user) of X, for simplicity take 3.
2. Only show the records where the priority field is set to greater or equal then 2.

Below is the query shown that is currently in existence that's supposed to achieve the above for all records having PhaseID of 3.

EDIT: the below query is formulated in the Priority field. So I need all Priorities with priority 1 not showing. That's essentially what the below is supposed to do, but it doesn't do anything.

IIf([Forms]![frm_OfferteEnOrderOpvolging]![PhaseID]=3,2,1) OR
IIf([Forms]![frm_OfferteEnOrderOpvolging]![PhaseID]=3,3,1)

Answer 1

I am not sure I get your point, why not:

 WHERE PhaseID>=[Forms]![frm_OfferteEnOrderOpvolging]![PhaseID]

Answer 2

Unless I am missing somthing it should just be a case of doing something like this

WHERE (((tblFoo.Phase_ID)=3) AND ((tblFoo.Priority)>=2 And (tblFoo.Priority)<>1))     
OR    (((tblFoo.Priority)>=2 And (tblFoo.Priority)<>1));

But you first question is not very clear so if you could repost I can tweak this SQL to suit