L
l_bush26
Hey guys,
I'm pretty new to access so i need some help.
I am making a business and I have made a query to show the number of
orders per month, and the total profit for that month. The problem is
for the first month, there is only one order, but that order has 3
jobs in it so it is counting it as 3 orders and is tripling the
profit. Which wouldn't be bad if it was actually true lol
this is what i have
SELECT DISTINCT Month([StartDate]) AS [Month], Count([StartDate]) AS
[Number of Orders], Sum(qryprofitpercent.[SumOfTotal Profit]) AS
[Total Profit]
FROM (tblWorkOrder INNER JOIN QryCost2 ON tblWorkOrder.WorkOrderID =
QryCost2.WorkOrderID) INNER JOIN qryprofitpercent ON
tblWorkOrder.WorkOrderID = qryprofitpercent.WorkOrderID
GROUP BY Month([StartDate]);
Thanks if you c
I'm pretty new to access so i need some help.
I am making a business and I have made a query to show the number of
orders per month, and the total profit for that month. The problem is
for the first month, there is only one order, but that order has 3
jobs in it so it is counting it as 3 orders and is tripling the
profit. Which wouldn't be bad if it was actually true lol
this is what i have
SELECT DISTINCT Month([StartDate]) AS [Month], Count([StartDate]) AS
[Number of Orders], Sum(qryprofitpercent.[SumOfTotal Profit]) AS
[Total Profit]
FROM (tblWorkOrder INNER JOIN QryCost2 ON tblWorkOrder.WorkOrderID =
QryCost2.WorkOrderID) INNER JOIN qryprofitpercent ON
tblWorkOrder.WorkOrderID = qryprofitpercent.WorkOrderID
GROUP BY Month([StartDate]);
Thanks if you c