Results 1 to 2 of 2
  1. #1
    Logix is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    3

    Combine 3 Queries


    I have 3 queries - how would I combine them to all report in 1 query?

    Code:
    SELECT Count([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS NumOfTrans, Sum([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Total
    FROM [Wires_I-incoming_O-outgoing];
    Code:
    SELECT COUNT([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Unique_Orig1
    FROM [Wires_I-incoming_O-outgoing]
    WHERE ([Wires_I-incoming_O-outgoing].Direction="O");
    Code:
    SELECT COUNT([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Unique_Orig
    FROM [Wires_I-incoming_O-outgoing]
    WHERE ([Wires_I-incoming_O-outgoing].Direction="I");
    thank you!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Assuming that they each has a related field (key), name each of the queries and then join them in a 3rd query just like you would join tables. If they have no common key, you're out of luck.

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

Similar Threads

  1. Combine crosstab queries
    By thart21 in forum Queries
    Replies: 3
    Last Post: 05-03-2010, 10:36 AM
  2. Combine queries
    By thart21 in forum Queries
    Replies: 1
    Last Post: 03-05-2010, 01:39 PM
  3. Combine fields into one
    By cotri in forum Forms
    Replies: 2
    Last Post: 03-04-2010, 02:42 PM
  4. Replies: 1
    Last Post: 05-28-2009, 05:08 AM
  5. Combine queries results in forms
    By frasilvio in forum Queries
    Replies: 12
    Last Post: 01-10-2008, 01:34 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