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.