aggregation problem

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

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 said:
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
Click to expand...

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.
 
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:(
 
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 said:
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:(
Click to expand...
 
Hello "thread".

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:(
Click to expand...

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.
 
Back
Top