Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Question Unanswered: "Duplicate Query-Duplicate Query More Table"


    Hi ! Im fresh in Ms Access ! I think there many expert would anwers my question within seconds ! If you can help , I'll very appreciate your help !

    My question is duplicate query wizard in access only can use for 1 table only !

    Example : I have 3 table .

    Table 1
    Name Age Sex
    John 18 male
    May 21 female
    Alex 22 male
    Amanda 20 female

    Table 2
    Name Age Sex
    Linda 22 female
    Helen 25 female
    Alan 23 male
    Adam 24 male
    John 18 male

    Table 3
    Name Age Sex
    May 19 female
    Bonnie 21 lesbian
    Leon 22 gay
    John 18 male

    How Can I use duplicate query to find out John within 3 table ?

    from , jeremy(
    malaysia)
    Last edited by keong04; 05-20-04 at 14:41.

  2. #2
    Join Date
    Apr 2004
    Posts
    130
    Append them into one table (possibly temporary) using Make table and then Append. Might not be what you want, but will do the job.

    Winston

Posting Permissions

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