Tell me exactly what you are trying to get with this query and how
tblAMUWork relates to tblAMURptsRecd.

The logic that I read in the query is this:
1) Filter all records in tblAMUWork so as only to return those records
that have a given DateRcd and MISNumber.
2) Return the selected fields from tblAMUWork and tblAMURptsRecd where
RptName = AMURptName

Is that what you're trying to get out of this?

Cheers,
Jason Lepack