Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

aggregation problem

Discussion in 'Information Technology' started by thread, Jul 28, 2006.

  1. thread

    thread
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    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
     
  4. thread

    thread
    Expand Collapse
    Guest

    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
     
  5. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    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" <yaniv.dg@gmail.com> wrote in message
    news:1151235421.121680.305350@b68g2000cwa.googlegroups.com...
    > 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

    >
     
  6. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    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
     

Share This Page