Counting days in a group by query less than....

[Coach K]

I am trying to get the following SQL statement to work but everytime I run it
i get the message that "its is to complex"

here is the statement:

SELECT Format([REC_DATE],"yyyy\-mm") AS TheMonth, Count([TAT-TOTAL]) AS
[CountOfTAT-TOTAL]
FROM [qryFGD-SOUTHERN-RES-AE]
WHERE [TAT-TOTAL] <= 15
GROUP BY Format([REC_DATE],"yyyy\-mm");



Thanks for your help in advance!!

 

[Jeff Boyce]

Have you tried stripping out pieces until it does work, then building back
up to identify what's confusing Access?

Another approach might be to build a "chain" of queries, each one using the
previous query's result as the source? That way you could do the simplest
pieces first, then add complexity in subsequent query(ies).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

I suspect that qryFGD-SOUTHERN-RES-AE is generating an error in one or
more the results for Rec_Date and when you trying formatting that in
this query you are getting the Too Complex error.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================