Using IFF statement to parse out data in query

[Mimzy_AK]

Hi all. I've been directed to build a new job tracking access database and I've run into an issue I need help with.

Basically I have a field named Work_Type which is currently a drop down combo box tracking the three types of work we do. We'll call them X, Y, and Z. I'm currently trying to create a query that parses out the data entries based on the Work_Type field so I can use it for further processing. Basically I need something that does roughly this:

IFF [Work_Type] = "X" THEN include the data entry in the query, otherwise skip that line entirely and move on.

Is what I want to do even possible? I was unable to find an example like this using my Google Fu. Any suggestions, or should I try and find myself some sort of work around?

Thanks much in advance for any help!

 

[plog]

Overthinking Alert:

IFF [Work_Type] = "X" THEN include the data entry in the query, otherwise skip that line entirely and move on.

You just described criteria. In design view of the query, bring down the Work_Type field and beneath it, in the criteria section put "X". No IIf statement needed.

 

[Mimzy_AK]

/facepalm

Oh geeze. That was way easier then I ever would have expected. Thank you so much!