Aggregate Function Error

Results 1 to 2 of 2

Thread: Aggregate Function Error

  1. #1
    Join Date
    Dec 1969

    Default Aggregate Function Error

    This error has always baffled me. It occurs sometimes when I use a GROUP BY clause in an SQL statement. Get rid of the grouping and it always works. Anybody know why? <BR><BR>Error Type:<BR>Microsoft JET Database Engine (0x80040E21)<BR>You tried to execute a query that does not include the specified expression &#039;author&#039; as part of an aggregate function.<BR><BR>Thanks <BR>-Ben

  2. #2
    Join Date
    Dec 1969

    Default RE: Aggregate Function Error

    If you have a group by clause then all columns in the select list must either be present in the group by clause or used in an aggregate function.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts