BruceFrey
Registered User.
- Local time
- Today, 16:38
- Joined
- Dec 12, 2002
- Messages
- 20
Hello
I have a query fed by 3 tables and 2 queries. For years the query displayed my data with no problems. However, when I added a large number of extra fields to what was already a large number of fields I get the error above.
I've found that if I delete 12 or more fields the query will run. I'd like to keep those fields though since it will cause me more work bringing them back to the data. In my query every field except one is a group by since I have totaling turned on. There is one expression field.
I tried going to sql view and deleting all the group by fields except the one key field but get the error You tried to execute a query that does not include the specified expression 'Program Name' as part of an aggregate function. Program Name is my first field in the query. I tried deleting the field but the error then gives me my second field.
I do not know sql but do know enough to go to the view and change something.
Any suggestions or comments would be welcome.
I have a query fed by 3 tables and 2 queries. For years the query displayed my data with no problems. However, when I added a large number of extra fields to what was already a large number of fields I get the error above.
I've found that if I delete 12 or more fields the query will run. I'd like to keep those fields though since it will cause me more work bringing them back to the data. In my query every field except one is a group by since I have totaling turned on. There is one expression field.
I tried going to sql view and deleting all the group by fields except the one key field but get the error You tried to execute a query that does not include the specified expression 'Program Name' as part of an aggregate function. Program Name is my first field in the query. I tried deleting the field but the error then gives me my second field.
I do not know sql but do know enough to go to the view and change something.
Any suggestions or comments would be welcome.
