Sabtu, 22 Oktober 2011

[MS_AccessPros] Sum function in a query

 

I have a database with records to our web site counted per page. I am
planning to report on separate folders. I have prepared a query that
shows 1494 visitors to the pages in the /benalla/ folder.

When I run this SQL:

SELECT Sum([qStatsYTD/clubs/Benalla/].Visitors) AS SumOfVisitors
FROM [qStatsYTD/clubs/Benalla/];

I get a sum of 5057.

What I have done incorrectly?

The results query that is counted is below.

Many thanks,

Robin Chapple

StatsID Page Visitors
80 Rotary Club of Benalla Home Page
(http://www.rotary9790.org.au/clubs/atoc/benalla/) 470
277 About Rotary Club of Benalla
(http://www.rotary9790.org.au/clubs/atoc/benalla/about.asp) 176
382 Rotary Club of Benalla Snippets From Club Bulletins
(http://www.rotary9790.org.au/clubs/atoc/benalla/snippets.asp) 135
357 http://www.rotary9790.org.au/clubs/atoc/benalla/about.htm 134
539 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/juniorawards.asp) 106
723 Rotary Club of Benalla
(http://www.rotary9790.org.au/clubs/atoc/benalla/legends.asp) 74
708 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/vanuatu.asp) 69
787 Rotary Club of Benalla
(http://www.rotary9790.org.au/clubs/atoc/benalla/kellymcnamara.asp) 62
769 Rotary Club of Benalla
(http://www.rotary9790.org.au/clubs/atoc/benalla/youth.asp) 62
911 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/salvos.asp) 49
1033 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/festival.asp) 42
1105 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/golfday.asp) 38
1190 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/benallarawcsteam.asp) 36
1254 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/bbqsep2010.asp) 32
2329 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/newmem.asp) 4
2321 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/balloons.asp) 3
3025 Rotary Club of Benalla - Vale Gerrard Crothers
(http://www.rotary9790.org.au/clubs/atoc/benalla/valecrothers.asp) 1
3024 Rotary International District 9790
(http://www.rotary9790.org.au/clubs/atoc/benalla/board0910.asp) 1

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar