SELECT PlantSpecies.PlantSpeciesID, PlantSpecies.SciName, PlantSpecies.ComName, PlantPractices.PlantRate, PlantPractices.PlantUnit

FROM (Criteria INNER JOIN (ConservationPlan INNER JOIN PlantPractices ON ConservationPlan.PlanNumber = PlantPractices.Plan) ON Criteria.SciName = PlantPractices.SciName) INNER JOIN PlantSpecies ON Criteria.SciName = PlantSpecies.SciName

WHERE (

(([Forms]![002_Criteria].[NFixer])=-1) AND ((Criteria.nfixer)=-1) 
AND (([Forms]![002_Criteria].[TolerantSun])=-1) AND ((Criteria.TolerantSun)=-1) 
AND (([Forms]![002_Criteria].[TolerantShade])=-1) AND ((Criteria.TolerantShade)=-1) 
AND (([Forms]![002_Criteria].[TolerantWind])=-1) AND ((Criteria.TolerantWind)=-1) 
AND (([Forms]![002_Criteria].[TolerantSalt])=-1) AND ((Criteria.TolerantSalt)=-1) 
AND (([Forms]![002_Criteria].[Pollinator])=-1) AND ((Criteria.Pollinator)=-1) 
AND (([Forms]![002_Criteria].[Native])=-1) AND ((PlantSpecies.Native)=-1) 
AND (([Forms]![002_Criteria].[Introduce])=-1) AND ((PlantSpecies.introduce)=-1) 
AND ((PlantPractices.Plan)=[Forms]![002_Criteria]![cboPlan]) AND ((PlantSpecies.AOI)=[Forms]![001_Selection].[ListAOI])) 

OR (

(([Forms]![002_Criteria].[NFixer])=0) AND ((Criteria.nfixer)=-1 Or (Criteria.nfixer)=0) 
AND (([Forms]![002_Criteria].[TolerantSun])=0) AND ((Criteria.TolerantSun)=-1 Or (Criteria.TolerantSun)=0) 
AND (([Forms]![002_Criteria].[TolerantShade])=0) AND ((Criteria.TolerantShade)=-1 Or (Criteria.TolerantShade)=0) 
AND (([Forms]![002_Criteria].[TolerantWind])=0) AND ((Criteria.TolerantWind)=-1 Or (Criteria.TolerantWind)=0) 
AND (([Forms]![002_Criteria].[TolerantSalt])=0) AND ((Criteria.TolerantSalt)=-1 Or (Criteria.TolerantSalt)=0) 
AND (([Forms]![002_Criteria].[Pollinator])=0) AND ((Criteria.Pollinator)=-1 Or (Criteria.Pollinator)=0) 
AND (([Forms]![002_Criteria].[Native])=0) AND ((PlantSpecies.Native)=-1 Or (PlantSpecies.Native)="0") 
AND (([Forms]![002_Criteria].[Introduce])=0) AND ((PlantSpecies.introduce)=-1 Or (PlantSpecies.introduce)="0") 
AND ((PlantPractices.Plan)=[Forms]![002_Criteria]![cboPlan]) AND ((PlantSpecies.AOI)=[Forms]![001_Selection].[ListAOI]));