Query Help - Show field if another field is null

[lukekonrad]

hello , i am working on a school project and am stuck on the last part. I need to produce a query for use as a report. The fields in the query are:

Building
Teacher 1
Teacher 2
Teacher 3
Teacher 4
Archive 1
Archive 2
Archive 3
Archive 4

"building" is the search parameter for the query

I need to produce a list of names of teachers, if there is nothing entered into the corresponding archive number e.g. no data in archive 1 and 3 , so show teacher 1 and 3.

Hope ive explained this properly, any help would be much appreciated

[Robeen]

Let me get this straight.
If there is no data in Archive1 & Archive3 - then you want to see Teacher1 and Teacher 3?
What If there is no data in Archive1 & Archive3 & Archive2 & Archive4 - then you want to see Teacher1, 2, 3 & 4?

What fields will your final query have?