ok i will continue from where sweetsh stopped.
ok i dont know the exact question.
but i will tell the general things to be done in this query.
- shows a summary of only the Code and Potential Area fields
After that new row appears.
for code , u can select group by (do not select group by for potential area, because we want its sum so leave it intact)
performs a count of the number of sites in each Codeput sites as a new column
in that new row, select "Count", this will count the number of sites.
• calculates the sum of the Potential Area within each code
in the potential area column, select sum.
i think ur done!