Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: How to write the query?

    Hi:
    In MS Access
    I have a table, 2 queries:

    One of the queries have input: [Enter value:]
    Second of the queries use the previous query to run.

    Query: Retrieve Invoices
    SELECT Input.*
    FROM [Input]
    WHERE (((Input.[Date Received])>=[Start Date:] And (Input.[Date Received])<[End Date];

    Query: Not Received Invoices
    SELECT DISTINCT [Vendor List].[Vendor Name], [Vendor List].[Vendor Code], [Vendor List].[Billing Code], "Accrual" AS [Invoice Date]
    FROM [Vendor List] LEFT JOIN [Retrieve Invoices] ON [Vendor List].[Vendor Name] = [Retrieve Invoices].[Vendor Name - Long]
    WHERE ((([Vendor List].[Billing Code])="BC 1" Or ([Vendor List].[Billing Code])="BC 2") AND (([Vendor List].Status)="Active") AND (([Retrieve Invoices].[Vendor Name - Long]) Is Null));

    So, How can I combine 2 queries into one query using the SQL View.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    union query

    BUT make shore the Column are in the same place
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Sep 2005
    Posts
    313
    No,
    i don't need to output the result of the Query: Received Invocies, that one just retrieve the part of the invoices.

    Thanks.

Posting Permissions

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