aggregate function error message??

Each time I try to open one of my queries I get an error message which tells
me that 'You tried to execute a query that does not include the specified
expression '[name]' as part of an aggregate function'. I have never come
across this before in Access can anyboby explain what it means??

thanks

Craig

hi,

zakbelle wrote:
Each time I try to open one of my queries I get an error message which tells
me that 'You tried to execute a query that does not include the specified
expression '[name]' as part of an aggregate function'. I have never come
across this before in Access can anyboby explain what it means??
This means, that in your SQL statement you have a line like

GROUP BY field1, ..., fieldN

each of this fields must be part of your selection, either as plain
field or as an aggregate, e.g.

SELECT field1, ..., Avg(fieldN)


mfG
-- stefan --

Thanks for the reply Stefan, can I remove this line? I'm not sure of its
significance and I may have entered something by mistake but its seriously
disrupting my database

regards

Craig

"Stefan Hoffmann" wrote:

hi,

zakbelle wrote:
Each time I try to open one of my queries I get an error message which tells
me that 'You tried to execute a query that does not include the specified
expression '[name]' as part of an aggregate function'. I have never come
across this before in Access can anyboby explain what it means??
This means, that in your SQL statement you have a line like

GROUP BY field1, ..., fieldN

each of this fields must be part of your selection, either as plain
field or as an aggregate, e.g.

SELECT field1, ..., Avg(fieldN)


mfG
-- stefan --

hi,

zakbelle wrote:
Thanks for the reply Stefan, can I remove this line? I'm not sure of its
significance and I may have entered something by mistake but its seriously
disrupting my database
Nope, if you remove it, you will no longer get a grouped result (this
what the greek-S button does).


mfG
-- stefan --