MY REALLY BIG SQL STATEMENT
SELECT [Species Union - Prepare data for Search Query].Watershed, IsNull([forms]![search]![__watershed]) AS Expr1, [Species Union - Prepare data for Search Query].[Breeding Evidence], IsNull([forms]![search]![__breeding]) AS Expr2, [Species Union - Prepare data for Search Query].Dead, IsNull([forms]![search]![__dead]) AS Expr3, [Species Union - Prepare data for Search Query].Municipality, IsNull([forms]![search]![__municipality]) AS Expr4, [Species Union - Prepare data for Search Query].Lot, IsNull([forms]![search]![__lot]) AS Expr5, [Species Union - Prepare data for Search Query].Concession, IsNull([forms]![search]![__concession]) AS Expr6, [Species Union - Prepare data for Search Query].SpeciesID, [Species Union - Prepare data for Search Query].Latin, [Habitat Matrix - Prepare data for Search Query].CommonName, [Species Union - Prepare data for Search Query].fulldate FROM [Habitat Matrix - Prepare data for Search Query] INNER JOIN [Species Union - Prepare data for Search Query] ON [Habitat Matrix - Prepare data for Search Query].latin = [Species Union - Prepare data for Search Query].Latin WHERE ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND (([Species Union - Prepare data for Search Query].Concession)=[forms]![search]![__concession])) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND (([Species Union - Prepare data for Search Query].Lot)=[forms]![search]![__lot]) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND (([Species Union - Prepare data for Search Query].Municipality)=[forms]![search]![__municipality]) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND (([Species Union - Prepare data for Search Query].Dead)=[forms]![search]![__dead]) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND (([Species Union - Prepare data for Search Query].[Breeding Evidence])=[forms]![search]![__breeding]) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR ((([Species Union - Prepare data for Search Query].Watershed)=[forms]![search]![__watershed]) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False)) OR (((IsNull([forms]![search]![__watershed]))<>False) AND ((IsNull([forms]![search]![__breeding]))<>False) AND ((IsNull([forms]![search]![__dead]))<>False) AND ((IsNull([forms]![search]![__municipality]))<>False) AND ((IsNull([forms]![search]![__lot]))<>False) AND ((IsNull([forms]![search]![__concession]))<>False));