Quarterly Report Question

  • Thread starter Thread starter Kelly P
  • Start date Start date
K

Kelly P

I have a query that totals labor cost and sales as an expression, and pulls
into a report. What I'm needing it to do is pull the total in by quarter,
have tried several options with no luck...any suggestions would be greatly
appreciated.
 
Try this --
SELECT Format([YourDate], "yyyy q") as Year_QTR, Sum([AmountField]) AS
QTR_Total
FROM Your Table
GROUP BY Format([YourDate], "yyyy q");
 
here is the code I already have in:
SELECT
Sum([lprice1]+[lprice2]+[lprice3]+[lprice4]+[lprice5]+[lprice6]+[lprice7]+[lprice8]+[lprice9]+[lprice10])
AS labor,
Sum([price]+[price1]+[price2]+[price3]+[price4]+[price5]+[price6]+[price7]+[price8]+[price9]+[price10]) AS Parts, Sum(Invoice.Tax) AS SalesTax
FROM Invoice;
I get errors when I try to add the qtr part in, but I am fairly new to
access and might not be coding it correctly.

KARL DEWEY said:
Try this --
SELECT Format([YourDate], "yyyy q") as Year_QTR, Sum([AmountField]) AS
QTR_Total
FROM Your Table
GROUP BY Format([YourDate], "yyyy q");

--
KARL DEWEY
Build a little - Test a little


Kelly P said:
I have a query that totals labor cost and sales as an expression, and pulls
into a report. What I'm needing it to do is pull the total in by quarter,
have tried several options with no luck...any suggestions would be greatly
appreciated.
Click to expand...
Click to expand...
 
Got it! Thanks for the help!

KARL DEWEY said:
Try this --
SELECT Format([YourDate], "yyyy q") as Year_QTR, Sum([AmountField]) AS
QTR_Total
FROM Your Table
GROUP BY Format([YourDate], "yyyy q");

--
KARL DEWEY
Build a little - Test a little


Kelly P said:
I have a query that totals labor cost and sales as an expression, and pulls
into a report. What I'm needing it to do is pull the total in by quarter,
have tried several options with no luck...any suggestions would be greatly
appreciated.
Click to expand...
Click to expand...
 
Back
Top