Results 1 to 2 of 2
  1. #1
    riantoaji is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    2

    make relasion with one query with other query


    hello
    i am a beginner here,i am sorry if ask a question.
    i have a problem with my database,i have a query A.i want to find a datediff with one field in my table and so i spread with 2 queries,query 1 and query 2 and then i make a relation between query 1 and 2,and then i got a datediff in other query"query 3".and i want to put 1 field from query 3 to query A and if i run i got the double record. give me the best solution please.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    set the last query property to unique values = true
    (no duplicates)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-02-2014, 09:26 AM
  2. Replies: 3
    Last Post: 11-29-2012, 11:22 PM
  3. Replies: 1
    Last Post: 05-24-2012, 03:29 AM
  4. Need help to make a query
    By fabilewk in forum Queries
    Replies: 5
    Last Post: 07-29-2011, 08:29 AM
  5. Replies: 1
    Last Post: 07-30-2010, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums