Welcome to SPN

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

Sign Up Now!

Query problems

Discussion in 'Information Technology' started by Phil, Nov 2, 2005.

Tags:
  1. Phil

    Phil
    Expand Collapse
    Guest

    I have a query that works just the way I want it to, however when I add
    another field from another table to limit the data displayed, I cannot edit
    any of the data in the query.

    The new field is only there to limit the results, it isn't even displayed,
    is there anyway I can limit the information using this field but still be
    able to edit data in the query?


    Any help would be great
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Editing data through queries is limited. I found this information through
    Google:

    You cannot update a query that is based on three or more tables containing
    many-to-one-to-many relationships.

    You cannot edit the data in a crosstab query, certain SQL pass-through
    queries, a query whose unique value property is set to Yes, a query including
    linked ODBC tables, or a paradox table without a primary key.

    Hope this helps.


    "Phil" wrote:

    > I have a query that works just the way I want it to, however when I add
    > another field from another table to limit the data displayed, I cannot edit
    > any of the data in the query.
    >
    > The new field is only there to limit the results, it isn't even displayed,
    > is there anyway I can limit the information using this field but still be
    > able to edit data in the query?
    >
    >
    > Any help would be great
    >
    >
    >
    >
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Try using the second table as criteria and not joined. I think you would
    have a criteria for the field you would normally join and and another for the
    field you are using to limit the data.

    "Phil" wrote:

    > I have a query that works just the way I want it to, however when I add
    > another field from another table to limit the data displayed, I cannot edit
    > any of the data in the query.
    >
    > The new field is only there to limit the results, it isn't even displayed,
    > is there anyway I can limit the information using this field but still be
    > able to edit data in the query?
    >
    >
    > Any help would be great
    >
    >
    >
    >
     
  5. Phil

    Phil
    Expand Collapse
    Guest

    It is a select query which only consists of 2 tables, the unique property is
    set to no. I'm unsure about the other examples here.. what exactly is a
    paradox table?


    Cheers


    "xRoachx" <xRoachx@discussions.microsoft.com> wrote in message
    news:E4EC634F-2928-4911-BC47-B9897A2A8679@microsoft.com...
    > Editing data through queries is limited. I found this information through
    > Google:
    >
    > You cannot update a query that is based on three or more tables containing
    > many-to-one-to-many relationships.
    >
    > You cannot edit the data in a crosstab query, certain SQL pass-through
    > queries, a query whose unique value property is set to Yes, a query
    > including
    > linked ODBC tables, or a paradox table without a primary key.
    >
    > Hope this helps.
    >
    >
    > "Phil" wrote:
    >
    >> I have a query that works just the way I want it to, however when I add
    >> another field from another table to limit the data displayed, I cannot
    >> edit
    >> any of the data in the query.
    >>
    >> The new field is only there to limit the results, it isn't even
    >> displayed,
    >> is there anyway I can limit the information using this field but still be
    >> able to edit data in the query?
    >>
    >>
    >> Any help would be great
    >>
    >>
    >>
    >>
     

Share This Page