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

  • Thread starter Thread starter Coach K
  • Start date Start date
C

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!!
 
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
 
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
'====================================================
 
Back
Top