select Cnt,KML,Countyname,REGION from ( select C.*,Waterplan from ( select Cnt,a.Countyname,KML from ( select Countyname,KML,Lat,-[Long] as Lng from county in "h:\\agdb\\agdb.mdb" where KML ) as a left join ( Select count(*) as Cnt,County as Countyname from (select distinct #FLD#,County from QEvents where county #COND#) group by County ) as b on a.Countyname=b.Countyname ) as c left join County as d on c.countyname=d.countyname ) order by 4 select Cnt,Countyname,Countyname,REGION from ( select C.*,Waterplan from ( select Cnt,a.Countyname from ( select Countyname from county in "h:\\agdb\\agdb.mdb" where KML ) as a left join ( Select count(*) as Cnt,County as Countyname from (select distinct #FLD#,County from QEvents where county #COND#) group by County ) as b on a.Countyname=b.Countyname ) as c left join County as d on c.countyname=d.countyname ) order by 4 select Cnt,a.City,Lat,Lng from ( select City,max(Lat) as Lat,max(-[Long]) as Lng from zip where state="GA" and lat and City group by City ) as a left join ( Select count(*) as Cnt,SiteCity as City from QEvents where SiteCity #COND# group by SiteCity ) as b on a.City=b.City where Cnt>0 select Cnt,KML,WShedName,WShedName from ( select C.* from ( select Cnt,a.WShedName,SCoord as KML from [8HUC] as a left join ( Select count(*) as Cnt,WShedName from (select distinct #FLD#,WShedName from QEvents where [8HUC] #COND#) group by WShedName ) as b on a.WShedName=b.WShedName ) as c ) order by 4 select Cnt,WShedName,WShedName,WShedName from ( select C.* from ( select Cnt,a.WShedName from [8HUC] as a left join ( Select count(*) as Cnt,WShedName from (select distinct #FLD#,WShedName from QEvents where [8HUC] #COND#) group by WShedName ) as b on a.WShedName=b.WShedName ) as c ) order by 4

Summarize

 by

Colors represent number of

Click a to view data.
Right-click to open in new window.