#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    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
  3. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Aug 2009
    Posts
    6
    Rep Power
    0
    I think I've sorted this one now by having an iif statement instead.

Similar Threads

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

IMN logo majestic logo threadwatch logo seochat tools logo