Group query results

[shak2]

I have a query, this is the code I used to get what I wanted:

SELECT [Master Approved Days].[Date], [Master Approved Days].[Record Number], [Master Approved Days].[Approved Days 1], Count([Master Approved Days].[Approved Days 1]) AS [CountOfApp Days]
FROM [Master Approved Days]
GROUP BY [Master Approved Days].[Date], [Master Approved Days].[Record Number], [Master Approved Days].[Approved Days 1];

The [Approved Days 1] field lists all possible durations, so from 1, 2, 3, 4, through '>7.' I want to put a grouping/clause in my code so that I can split this range into <=3, >3 days, and have the query count all those greater than 3, and less than or equal to 3.

Any ideas?

[Sal_v]

Create two fields (xx and kount):
xx:IIf([Approval_days]>3,">3","<=3")
kount:Count([Approval_days])
Group on xx

SELECT IIf([Approval_days]>3,">3","<=3") AS xx, Count(tblMstrAppDays.[Approval_days]) AS kount
FROM tblMstrAppDays
GROUP BY IIf([Approval_days]>3,">3","<=3");

[shak2]

Create two fields (xx and kount):
xx:IIf([Approval_days]>3,">3","<=3")
kount:Count([Approval_days])
Group on xx

SELECT IIf([Approval_days]>3,">3","<=3") AS xx, Count(tblMstrAppDays.[Approval_days]) AS kount
FROM tblMstrAppDays
GROUP BY IIf([Approval_days]>3,">3","<=3");

I keep getting syntax error on this part of the statement:
xx:IIf([Approval_days]>3,">3","<=3")
kount:Count([Approval_days])
Group on xx
It keeps saying that i'm missing an operator

[shak2]

Create two fields (xx and kount):
xx:IIf([Approval_days]>3,">3","<=3")
kount:Count([Approval_days])
Group on xx

SELECT IIf([Approval_days]>3,">3","<=3") AS xx, Count(tblMstrAppDays.[Approval_days]) AS kount
FROM tblMstrAppDays
GROUP BY IIf([Approval_days]>3,">3","<=3");

ok this isn't working period. It makes no sense

[Sal_v]

I'm getting an error uploading the db. send me an email (via pm)

[shak2]

I have no idea what you're talking about.

[Sal_v]

let me re-phrase it, I cannot upload a database with an example/solution. If you want the db, send me a pm(private message through the forum) with your email so I can send you the db directly.

[weekend00]

Shak2:
If you provide an example, we can understand you much better and easier.