I am using an MSAccess db. I have a SQL statement selecting the records based on two factors:
tblGeneral.Designation = 'Yes'
tblGeneral.Status = 'Closed'
I then want to display city, state grouped alphabetically by the Complexity [field].
The final report should look like:
- Cleveland (Brecksville)
- Menlo Park
- Pittsburgh (Highland Park)
- San Anotonio
- West Roxbury
- Iowa City
Code is generating the following error:
Microsoft JET Database Engine error '80040e21'
You tried to execute a query that does not include the specified expression 'ChartID' as part of an aggregate function.
I am attaching a sample database and the code.