Multi-Level Group by clause not allowed in subquery error?

[rt52]

Given the sql statement:

rptSQL = "SELECT [tbIntervention].[loc], " & _
"Count([tbIntervention].[loc]) AS [Number], " & _
"Count([tbIntervention].[loc])/" & _
"(Select Count([tbIntervention].[loc]) " & _
"FROM tbIntervention WHERE " & _
dateSQL & " AND " & cboSQL & ") AS [percent] " & _
"FROM tbIntervention "
The report has a loc group, number and percent fields in detail, and sum(number) and sum(percent) in report footer.

What does the error mean?

 

[lupins46]

Can't see a problem here.

What are DateSql and cboSQL?

 

[rt52]

Hello.
This is the first part of a longer sql. datesql and combo sql comprise the "where" statement - both are derived from combobox choices. This sql statement worked until I added the "Count([tbIntervention].[loc])/" & _
"(Select Count([tbIntervention].[loc]) "
part, and placed [percent] in a field on the report. This thread is actually a secondary issue of thread 701-938950.
Thanks for looking.