Query help

[stanger1]

I have a report based on a query. I want to be able to show a field on the report from the results of my query, but not be part of the criteria for the query. If I add the field to my query, I get more records than what I need. Is there a way to get the field I want to show up on the report without adding it to the criteria of my query? Any help would be greatly appreciated.

 

[stanger1]

Pat,

Thanks for the reply!
I am trying to find a record called test_no. Under test_no there is a field called accept_reject. The field accept_reject can have many entries for every test_no. I want to be able to find the last entry in the accept_reject for test_no.