Re: Conditional test to combine multiple records

Hi Inkman,

I have tried this, but then I get errors displaying the query.

I get the error: "You tried to execute a query that does not include
the specified expression "EXPRESSION HERE" as part of an aggregate
function."

.

Relevant Pages

  • RE: Report totals depending on value in field
    ... You tried to execute a query that does not include the specified expression ... "Thel" wrote: ...
    (microsoft.public.access.reports)
  • Re: aggregate function error
    ... "You tried to execute a query that does not include the specified ... expression 'Individuals.' as part of an aggregate function." ...
    (microsoft.public.access.queries)
  • Re: Show results in a querrie
    ... "You tried to execute a query that does not include the specified expression ... as part of an aggregate function or grouping. ...
    (microsoft.public.access.queries)
  • Re: question about sql
    ... > errors is "you tried to execute a query that does not include the ... > specified expression 'name' as part of an aggregate function ...
    (microsoft.public.vb.general.discussion)
  • Max(), Min() Problem
    ... Select sh,MAXas Maxrm, MINas Minrm ... "you tried to execute a query that does not include the specified expression ...
    (microsoft.public.access.queries)