I have an end result in mind, but I just cannot figure out the best way to
get to this result. I have a database on staff and drills performed. One
table has staff first and last names. A second table has the first name (a
relationship linking this table's first name to the first table's first
name), date, station, time to ID, pass/fail, and observer. From the
information I have entered, I want to make a list of all staff who have
failed a drill. I have one column for pass and fail, so how to I create
something so that it pulls only the fails from that column? Do I use a
query, form, or report for this?