Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Combining Access Queries

Results 1 to 2 of 2
Share This Thread →
  1. #1
    wyptaj is offline Registered User
    Join Date
    Aug 2009
    Posts
    6
    Rep Power
    0

    Combining Access Queries

    Hello,

    I have an access query which has dates and financials for events (Price, Cost and Profit).

    I have another query which has an employees costs, profits by date and event.

    I need to somehow combine these queries so that :

    The list of price, costs and profit are displayed, and also add in a field for adjusted profits.

    I want the adjusted profits to be a calculation of Profit + Employee Profit. When I have done all the calculations, in the query there are figures in all boxes for the original financials. However the adjusted profits only show the entries where the employee has worked, and I wanted that column to show all profits plus the employee profits where applicable ?

    Is there any way to do this ?

    Many thanks in advance.

  2. #2
    wyptaj is offline Registered User
    Join Date
    Aug 2009
    Posts
    6
    Rep Power
    0
    I think I've sorted this one now by having an iif statement instead.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. Combining Queries
    By amdacra in forum Microsoft Access Help
    Replies: 5
    Last Post: May 15th, 2012, 05:22 PM
  2. Combining two queries
    By SQL_TC in forum SQL Development
    Replies: 1
    Last Post: November 12th, 2010, 12:33 PM
  3. COMBINING queries to Sum - HELP !!!
    By doubtfire in forum SQL Development
    Replies: 9
    Last Post: July 21st, 2007, 04:28 PM
  4. T-SQL help (combining queries)
    By superlu in forum SQL Development
    Replies: 2
    Last Post: March 28th, 2005, 01:47 PM
  5. Combining queries
    By mayde78 in forum Microsoft SQL Server
    Replies: 2
    Last Post: August 2nd, 2004, 09:52 AM

ASP Free Advertisers and Affiliates