Monitoring Transect Data (qry_Transect_Data) after selecting park, year (frm_Monitoring_Transect) include AverageCover for Dead species either as separate Dead Average Cover Column or Adding Y/N with IsDead & include average cover in same column
OR
Species Cover by Route after selecting park, year (frm_Species_Cover_by_Route) include AverageCover for Dead species by adding a Y/N column for IsDead
Two reports are impacted:
OR