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