Error Message

[JCowell]

You tried to execute a query that does not include the specified expression
'IIf([JCSugOrders]![JCBH]<=[BO-GF]![q_CSWWBOCHelp1],"","HMMMM")' as part of
an aggregate function.

Can anyone tell me why I may be getting this error? I've changed numerous
parts of this expression... I know it is most likely some basic rule or
something I'm not aware of. I a self taught Access user so much of what I do
may be unconventional please help.

Thanks

 

[John W. Vinson]

You tried to execute a query that does not include the specified expression
'IIf([JCSugOrders]![JCBH]<=[BO-GF]![q_CSWWBOCHelp1],"","HMMMM")' as part of
an aggregate function.

It means that you have a Totals query using that expression and it's not part
of an aggregate function (such as Sum, Count, etc.) - perhaps you just have it
in a vacant field cell and Access can't tell what it's for. (I can't either,
for that matter; for one thing you should not use the ! delimiter for
fieldnames, instead you should use a period).

Can anyone tell me why I may be getting this error? I've changed numerous
parts of this expression... I know it is most likely some basic rule or
something I'm not aware of. I a self taught Access user so much of what I do
may be unconventional please help.

If you'ld please open your query in SQL view and post it here, someone might
be able to help.