Criteria for each field does not allow me to get correct info

[survivo01]

I need to know whether a Student has a ABE or GED. Under some conditions I need to know only the students who do not have ABE and just the status of their GED. Do I have to do two queries. Obviously the two queries interact and don't allow me to get the correct info for either one.
Field	ABE	GED
Table	Students query	Students Query
Sort
Show
Criteria	[enter yes for ABE no for does not have]	[enter yes for GED no for does not have]

[June7]

Does this help:

Calculate a field in query:

Category: IIf(IsNull(ABE) AND IsNull(GED),"NONE", IIf(IsNull(ABE),"GED", IIf(IsNull(GED),"ABE", "BOTH")))

Can apply variety of criteria to that field.

[survivo01]

I am confused! IF ABE or GED are never null but either yes or no how does this formula work or was this an example for me to play with

[June7]

Sorry, missed that the fields are Yes/No type. Try:

Category: IIf([ABE] AND [GED], "BOTH", IIf([ABE], "ABE", IIf([GED], "GED", "NONE")))

Then apply criteria to that constructed field of "BOTH", "ABE", "GED", or "NONE".