Error regarding GROUP BY clause in subquery

[Tennarrow]

I'm receiving a strange error when I try to create a report. The basis of the report is a query that uses several subqueries; I successfully have used this query on previous forms I created. However, whenever I try to use this query with the report, I receive a strange error stating "Multilevel GROUP BY clause not allowed in subquery". I'm very confused by this, because I'm not actually using any GROUP BY clauses. My subqueries all look like this, where IssueType_ID is one example of a field in my query:

IssueType_ID: (SELECT tbl_IssueType.Description FROM tbl_IssueType WHERE tbl_Issuetype.Issuetype_ID = tbl_Issues.IssueType_ID)

As far as I can tell, my subquery is correct. Do reports interpret queries differently than forms? Am I missing something else? Any help would be appreciated.

 

[dhookom]

Reports like to rebuild your queries/record sources. I expect you are attempting to sort on the value(s) returned by one or more subquery. Reports won't allow this. Why don't you join tbl_IssueType to your query so you don't need to use a subquery? The other alternative that works (but I hate it) is DLookup() in place of the subquery.

Duane
MS Access MVP