Salesman Performance

I hv this data in my table

SalesID CustName SaleAmount NonPerformingTag
001 XXX 0.00 Y or N

How do i retrieve report or query for salesman who bringing in more than 50%
non performing account. Assuming out of 100 acct 50 acct turn out to be non
performing.

Appreciate your help

On Mon, 18 Feb 2008 16:02:01 -0800, zyus wrote:

I hv this data in my table

SalesID CustName SaleAmount NonPerformingTag
001 XXX 0.00 Y or N

How do i retrieve report or query for salesman who bringing in more than 50%
non performing account. Assuming out of 100 acct 50 acct turn out to be non
performing.

Appreciate your help


SELECT Sales.SalesID,
SUM(Sales.SaleAmount) AS [Total Sales],
SUM(IIF([NonPerformingTag] = -1,SaleAmount,0))AS [Non-Performing Sales],
SUM(IIF([NonPerformingTag] = -1,SaleAmount,0)) /
SUM(Sales.SaleAmount) * 100 AS [Non-Performing Amount Percentage],
SUM(IIF([NonPerformingTag] = -1,1,0)) / COUNT(* ) * 100
AS [Non-Performing Count Percentage]
FROM Sales
GROUP BY Sales.SalesID
HAVING (((SUM(IIF([NonPerformingTag] = -1,[SaleAmount],0)) /
SUM([SaleAmount]) * 100) 50));

"zyus" wrote in message
...
I hv this data in my table

SalesID CustName SaleAmount NonPerformingTag
001 XXX 0.00 Y or N

How do i retrieve report or query for salesman who bringing in more than
50%
non performing account. Assuming out of 100 acct 50 acct turn out to be
non
performing.

Appreciate your help

I think your data structure needs some work. CustomerName should be in a
Customer table and NonPerforming should be a boolean or integer column.
SalesID should just be ID, it does not need the name of its parent
prepended.

Michael

I use access basicly for data query and reporting. All of the data comes from
different system.

"Michael C" wrote:

"zyus" wrote in message
...
I hv this data in my table

SalesID CustName SaleAmount NonPerformingTag
001 XXX 0.00 Y or N

How do i retrieve report or query for salesman who bringing in more than
50%
non performing account. Assuming out of 100 acct 50 acct turn out to be
non
performing.

Appreciate your help

I think your data structure needs some work. CustomerName should be in a
Customer table and NonPerforming should be a boolean or integer column.
SalesID should just be ID, it does not need the name of its parent
prepended.

Michael

move any differentlymiss pals Sofia Filmmaker and Kim Gordon of Transonic Youngness, the indie pitching ring that wrought in New Royalty support in 1981, to his commerce relation of few 20 period, Robert Duffy.To this position Port Beckham may bonk to be supplemental, tho' her role in the season advertising operation for Marc wow gold[/url:y5vxaa1x]Writer has caused symptom to Jacobs devotees who mat she was a advocate tread t (http://ugamegold.com/:y5vxaa1x)

[align=left][align=left][size=36pt] *[size=12pt][color=#0000ff:3osze516]Warhammer gold[/color:3osze516][/size]*[/url:3osze516][/size][size=12pt], as the currency in the Warhammer world, plays an important role in the economic system. The experience plays take in game kinda depends on how much *Warhammer gold *they have. To amateur players, they do not have much time to play the game, not even farming [/size][size=36pt] *[size=12pt][color=#0000ff:3osze516]Warhammer online gold[/color:3osze516][/size]*[/url:3osze516][/size][size=12pt]. So most of Warhammer players would like to purchase /Warhammer gold/.[/size][/align][/align][align=left][align=left][size=12pt] [color=#282827:3osze516]Warhammer online CD-key[/color:3osze516][/url:3osze516] [/size][size=12pt]are the codes which be used to active your Warhammer Accounts. [/size][size=36pt] [size=12pt][color=#0000ff:3osze516]Warhammer online Timecard [/color:3osze516][/size][/url:3osze516][/size][size=12pt]then will be needed after your *Warhammer Accounts *have been activated. That means you have to use both *Warhammer CD-key *and *Warhammer Timecard *after you creat an *Warhammer account*, so that you can access to the *Warhammer* (http://www.mmogarden.com/war-all/cheap-gold-5-all&#46 (http://www.mmogarden&#46 (http://www.3zoom.com/uswarhammer-all/warhammer-cdkey-5-all&#46 (http://www.mmogarden.com/war-all/cheap-cdkey-5-all.html:3osze516)3osze516)3osze516)3osze516).
Buy *Warhammer CD-key *and* Warhammer Timecard *from us, experience our Instant delivery and Secure transaction.
For further information about the *Warhammer CD-key *and *Warhammer Timecard*, Please keep an eye on [color=blue:3osze516] warhammer powerleveling[/color:3osze516][/url:3osze516][/size][size=36pt][/size][/align (http://www.mmogarden.com/war-all/cheap-powerleveling-5-all.html:3osze516)gn]

[size=10:1mz0l9gv] *[color=#800080:1mz0l9gv]Warhammer online gold[/color:1mz0l9gv]*[/url:1mz0l9gv][/size:1mz0l9gv][size=10:1mz0l9gv], * [color=#800080:1mz0l9gv]Warhammer gold[/color:1mz0l9gv][/url:1mz0l9gv]*as the currency in the Warhammer world, plays an important role in the economic system. The experience plays take in game kinda depends on how much *Warhammer gold *they have. To amateur players, they do not have much time to play the game, not even farming *_[color=blue:1mz0l9gv]Warhammer gold[/color:1mz0l9gv]_*. So most of Warhammer players would like to purchase /Warhammer gold/. [color=#0000ff:1mz0l9gv]Warhammer Powerleveling[/color:1mz0l9gv][/url: (http://www.3zoom.com/: (http://www.3zoom.com/: (http://www.3zoom.com/war-all/cheap-powerleveling-5-all.html:1mz0l9gv)gv)gv)gv]
[color=#0000ff:1mz0l9gv]Warhammer online CDkey [/color:1mz0l9gv][/url:1mz0l9gv]are the codes which be used to active your Warhammer Accounts. [color=#0000ff:1mz0l9gv]Warhammer online timecard[/color:1mz0l9gv][/url:1mz0l9gv] then will be needed after your *Warhammer Accounts *have been activated. That means you have to use both *Warhammer CD-key *and *Warhammer Timecard *after you creat an *Warhammer account*, so that you can access to the *Warhammer* (http://www.3zoom.com/buy-game-card-5.html: (http://www.3zoom.com/buy-game-card-5.html:1mz0l9gv)gv).
Buy *Warhammer CD-key *and* Warhammer Timecard *from us, experience our Instant delivery and Secure transaction.[/size:1mz0l9gv]