28-Jul-2006, 08:25 AM
|
 | Guest | | | | | | | | |
| Re: aggregation problem
hi,
i'm trying to open via recordset a query:
rcd.Open " ", cn, adOpenDynamic, adLockOptimistic,
adCmdTable
and this is what i got in respond:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12007-aggregation-problem.html
"...is not part of aggregation
function...."
it seems like i cannot play with the data is the query when its group
by or as an expression,the only solution i found is to add another
culomn to use the data from the query and not with vba code
Wolfgang Kais wrote:
> Hi "thread".
>
> "thread" wrote:
> > hi all,
> > im trying to put data with recordset from a query and im getting
> > the aggregation error, how can i take the data for 1 single culomn
> > and not get the aggregation error
>
> Sorry, what are you trying to do?
> Do you mean selecting a column from a table?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12007
> Do you want to sum the values?
> I am not a native english speaker and I do not understand what you did.
> Maybe you can try to tell us what exactly you did.
>
> --
> Regards,
> Wolfgang
 |