Returning daily sales data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query set up that will display all my netsales data for the month. I
want to further break this down to show the sales for the day. I looked at
the SQL code and was trying to break it down a bit, for the monthly data it
looks like this:
Sum(([tblzzznetsales].[netsale]/day(now()))*[month_days]) as projected.
This will give me a projected sum of sales for the end of the month. I was
hoping I could leave of the last multiplier "*[month_days]) to get the days
sales, but it does not like the expression. Any ideas??
 
Is this what you are looking for?

SELECT Format([SaleDate],"d mmm yyyy") AS Sales, Sum(tblzzznetsales.netsale)
AS Total
FROM tblzzznetsales
GROUP BY Format([SaleDate],"yyyymmdd"), Format([SaleDate],"d mmm yyyy");
 
Back
Top