Results 1 to 3 of 3
  1. #1
    Join Date
    May 2016
    Posts
    2

    Answered: Join issue in Query

    Hey guys i have a "temporary" database i created but i am having problems on a query and i cannot figure out where i went wrong. The Query is called: Q_Excel_exportScaffoldListTime. In order to run the query you need to open the customer form. and then select the View edit project button. i use KBR as the customer and Yara as the project as this is where all of my test data is stored. once those forms are open you can open the query. The issue i am having is the query is producing duplicated results. but i cant resolve it.Estimation - Copy.zip

  2. Best Answer
    Posted by ranman256

    "its possible the query will give duplicates.
    but you can also turn that property off, by:
    in the query design, properties,
    set UNIQUE VALUES = yes"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    472
    Provided Answers: 22
    its possible the query will give duplicates.
    but you can also turn that property off, by:
    in the query design, properties,
    set UNIQUE VALUES = yes

  4. #3
    Join Date
    May 2016
    Posts
    2
    Ok i am not so brilliant. it looks like i just had a pile of data that i wasn't aware of. but thanks for your help

Posting Permissions

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