November 7th, 2012, 09:33 AM
Combining Access Queries
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.
November 7th, 2012, 10:06 AM
I think I've sorted this one now by having an iif statement instead.
By amdacra in forum Microsoft Access Help
Last Post: May 15th, 2012, 05:22 PM
By SQL_TC in forum SQL Development
Last Post: November 12th, 2010, 12:33 PM
By doubtfire in forum SQL Development
Last Post: July 21st, 2007, 04:28 PM
By superlu in forum SQL Development
Last Post: March 28th, 2005, 01:47 PM
By mayde78 in forum Microsoft SQL Server
Last Post: August 2nd, 2004, 09:52 AM