hi all,
im trying to put data with recordset from a query and im gettinhg the
aggregation error,
how can i take the data for 1 single culomn and not get the aggregation
error

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?
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

hi,
i'm trying to open via recordset a query:
rcd.Open "<query's name>", cn, adOpenDynamic, adLockOptimistic,
adCmdTable
and this is what i got in respond:
"<one of the culomns function>...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?
> 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

If you have a calculated field or if you Group By then no you cannot alter
the data in the recordset.

Think about it or a minute, the query engine expects that the recordset is
tied to the data in the table(s), if the data you extract is summarised in
any way then the query engine can not know which columns to update hence it
makes the recordset read only.


--

Terry Kreft


"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi,
> i'm trying to open via recordset a query:
> rcd.Open "<query's name>", cn, adOpenDynamic, adLockOptimistic,
> adCmdTable
> and this is what i got in respond:
> "<one of the culomns function>...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?
> > 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
>

Hello "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?
>> 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.

> i'm trying to open via recordset a query:
> rcd.Open "<query's name>", cn, adOpenDynamic, adLockOptimistic,
> adCmdTable
> and this is what i got in respond:
> "<one of the culomns function>...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

I see... not. You better post the SQL of <query's name>.
The message states that you use a query with a group by clause that
uses a source column that is neither part of an aggregate function nor
part of the group by clause. This is formidden.
Send the SQL and we can tell you more about a solution.

--
Regards,
Wolfgang