Include the 'id' field as part of the aggregate function (sum, group by,
avg, whatever)
> Can anyone give suggestions why I am getting the following error when
> selecting specific fields from an Access db, yet when I use a "select *"
> everything is fine?
>
> [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query
that
> does not include the specified expression 'id' as part of an aggregate
> function.
>
> thanks.
>
> Sincerely,
>
> Shane Witbeck
> Webmaster
> [EMAIL PROTECTED]
> www.digitalsanctum.com
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.