Quarterly Report Question

[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.

 

[KARL DEWEY]

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

 

[Kelly P]

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.

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

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.

 

[Kelly P]

Got it! Thanks for the help!

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

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.