Microsoft Access 2010 Help!?

Hello In access 2010 I have two columns type and status, with the type being either manual or hydraulic and the status being open or closed if the manual type is chosen and either normal or overridden open if hydraulic is chosen. How do I create the query allowing only open and closed to be shown in the status column if i choose the type to be manual?