1. My problem:
I am using a query to populate a Chart in MS Access 2k.
2. My query:
SELECT [3875 Open Item Status].Status, [Status Description].[Status
Description], Sum([3875 Current Open Items].Amount) AS SumOfAmount,
Sum(IIf([3875 Current Open Items]![Debit/Credit]="Debit",[3875 Current
Open Items]![Amount],[3875 Current Open Items]![Amount]*-1)) AS
realAmount, Count([3875 Open Item Status].Status) AS CountOfStatus
FROM ([3875 Open Item Status] INNER JOIN [Status Description] ON [3875
Open Item Status].Status = [Status Description].[Status Number]) INNER
JOIN [3875 Current Open Items] ON ([3875 Open Item Status].[Sch Num] =
[3875 Current Open Items].[Schedule Number]) AND ([3875 Open Item
Status].[Post Date] = [3875 Current Open Items].EffectiveDate)
WHERE ((([3875 Current Open Items]![EffectiveDate]) Between #10/1/2001#
And #9/30/2005#) AND (([3875 Open Item Status].Status)<>13 And ([3875
Open Item Status].Status)<>15))
GROUP BY [3875 Open Item Status].Status, [Status Description].[Status
Description]
ORDER BY Count([3875 Open Item Status].Status);
3. Here is the data returned from my query:
Status Description SumOfAmount NetAmount StatusCount
11 FBWT Balance Entry $20.00 $20.00 1
8 Closed Award $126,237.44 ($126,237.44) 2
12 ADI Error $7,591.00 $599.00 5
9 FUND 2915 SQL Needed $105,054.79 ($105,054.79) 6
14 Incomplete DV $174,501.44 ($174,501.44) 7
6 Oracle Reversed $25,707.51 ($25,707.51) 8
5 Over-Applied $12,504.15 ($9,871.65) 12
4 GAPs Reversed $52,389.81 $28,415.29 23
2 PreConversion $1,147,998.20 $1,147,998.20 105
4.All I need is a "Sum" or "Count" of the StatusCount Column
(which is a count of occurences of the Status Column). I am
new to Access and have searched thru the Access help file and
web for help but have found no answers. Can anyone help?
Thanx,
Chris