Here's the basic info:
Table:User
Source,text-
New,number - default = 1,always is 1
Act,number - default 0, will change to 1 at some point
Table:Company
CoName,text
AcctMgr,text - has many companies with one or more users and one or more sources
Select Query =
Co.AcctMgr
U.Source -group by nothing for now (count won't include uAct=0, sum gives 'type mismatch error')
U.Act -group by Sum
U.new -group by Sum
Pct
nz([u.act]))/nz([u.new])) Sort: Descending
Report = all the fields from query, grouped 1st by Pct and 2nd by AcctMgr.
The report should display
Percent/acctMgr/TotalNew/TotalAct/
I get:
100%/johnDoe/6/6
0%/johnDoe/1/0
I want:
85%/johnDoe/7/6
I have tried sorting the percent column at both the query level and the group level.
In either case it still splits acctMgrs and companies where ever the 'uAct' = 0.
Suggestions Welcome!
Thanks so much, and thanks to PaulBricker for pointing me in a better direction when I posed a variation on this question in Queries yesterday.
I have a monday-noon deadline, just to share some of my pressure with you!!
Thanks again,
yamy
Table:User
Source,text-
New,number - default = 1,always is 1
Act,number - default 0, will change to 1 at some point
Table:Company
CoName,text
AcctMgr,text - has many companies with one or more users and one or more sources
Select Query =
Co.AcctMgr
U.Source -group by nothing for now (count won't include uAct=0, sum gives 'type mismatch error')
U.Act -group by Sum
U.new -group by Sum
Pct
Report = all the fields from query, grouped 1st by Pct and 2nd by AcctMgr.
The report should display
Percent/acctMgr/TotalNew/TotalAct/
I get:
100%/johnDoe/6/6
0%/johnDoe/1/0
I want:
85%/johnDoe/7/6
I have tried sorting the percent column at both the query level and the group level.
In either case it still splits acctMgrs and companies where ever the 'uAct' = 0.
Suggestions Welcome!
Thanks so much, and thanks to PaulBricker for pointing me in a better direction when I posed a variation on this question in Queries yesterday.
I have a monday-noon deadline, just to share some of my pressure with you!!
Thanks again,
yamy