28-Jul-2006, 08:25 AM
| || |
| || || || || |
| || |
Re: aggregation problem
i'm trying to open via recordset a query:
rcd.Open "", cn, adOpenDynamic, adLockOptimistic,
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
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.