Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >>
    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page