Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unhappy Making report from 2 queries


    I have got a very simple database with a simple problem.
    I have got 2 queries:
    Query 1: Company name, Bill ID, Bill amount
    Query 2: Company name, Payment ID, Payment amount

    I want to creat a "Company bill-payment report" such that:
    1- When I click the report, it asks "Which company" (both queries are criteria based on company name, so I can get this, but it asks company name twice, even though the Company name fields are related in Relationship window)

    2-It gives each entry in either of the queries in one seperate line (I can't get this done. It matches the records and gives duplicates in each entry.)

    3-(Alternative to 2) The upper part of the report consists of the Query 1 results, the down part consists Query 2 results.

    I have got the simple database but it's in Turkish so I thought it may be inaudible. Though I can upload it if you think it helps easy understanding.

    I really appreciate your help, I need to get this done at the soonest time possible.

  2. #2
    Join Date
    Apr 2009
    Create a single query with all of the fields together. These fields should all be part of the same underlying table.

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

Similar Threads

  1. Making subforms editable
    By ashiers in forum Forms
    Replies: 7
    Last Post: 10-08-2008, 04:09 PM
  2. Making fields dissapear
    By rev_ollie in forum Access
    Replies: 0
    Last Post: 09-11-2008, 03:56 PM
  3. making specific fields non-editable
    By narayanis in forum Forms
    Replies: 3
    Last Post: 08-06-2008, 12:22 PM
  4. Making a new field in a query
    By mslieder in forum Queries
    Replies: 3
    Last Post: 05-14-2008, 11:44 AM
  5. Replies: 1
    Last Post: 03-22-2007, 10:19 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