[Solved] New Query gives error message
Posted: Mon Aug 06, 2018 12:50 pm
Hi,
I have a .odb file that contains a number of Queries that all work fine. I added a new column headed " IHT 405" to the Table and populated it with single-character entries. I then made a new Query, copying exactly the content of one of the existing, working, Queries except that I changed the Field to "IHT405" (the original Field column is also populated with single-character entries).
I also retained the original "Group" selection in the Function field for the new Query and then tried to run it.
I got an error message "Not in aggregate function or group by clause"
Any assistance would be greatly appreciated.
CRB
I have a .odb file that contains a number of Queries that all work fine. I added a new column headed " IHT 405" to the Table and populated it with single-character entries. I then made a new Query, copying exactly the content of one of the existing, working, Queries except that I changed the Field to "IHT405" (the original Field column is also populated with single-character entries).
I also retained the original "Group" selection in the Function field for the new Query and then tried to run it.
I got an error message "Not in aggregate function or group by clause"
Any assistance would be greatly appreciated.
CRB