I am trying to add data from 10 fields based on 2 criteria to get a total for each record.
I then need to display the totals in a table.
My SQL statement is not correct. It is giving me the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '( (select SUM(FTE1)....
I am attaching code and database.