Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query with undefined results (Access 2000)

    In my query called qryCorrespondences i have a field called PerformaqnceLevel which seems not to reflect the data entered in the form but gives only the same results .The results are true in the table but false in the query.How could i improve my query ? I am sending the databse in the attchement
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: query with undefined results (Access 2000)

    You have two copies of tblProducts in the query. All of them return the same product from tblproducts and different values from tblProducts_1.If you want Performance Level to be different, you need to get it from Products_1 not from Products.
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: query with undefined results (Access 2000)

    I think you need to refer to the Products_1 table for that field.

  4. #4
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query with undefined results (Access 2000)

    Yes ! Thank you both of you, it works now !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •