Group dates in query

D

drtaclem

I have a database which is part of a service industry. There are weekly
services. For billing I can sum the pricing for each service, but I would
like to show the individual dates next to the billing line on the report. Is
this possible? Can you put an array inside a query?
This is query for billing for each month...

SELECT qryRecWorkAnalysisBilling.CustName, qryRecWorkAnalysisBilling.Service,
qryRecWorkAnalysisBilling.SubService, Sum(qryRecWorkAnalysisBilling.
TotalPrice) AS SumOfTotalPrice, qryRecWorkAnalysisBilling.Year,
qryRecWorkAnalysisBilling.Months
FROM qryRecWorkAnalysisBilling
GROUP BY qryRecWorkAnalysisBilling.CustName, qryRecWorkAnalysisBilling.
Service, qryRecWorkAnalysisBilling.SubService, qryRecWorkAnalysisBilling.Year,
qryRecWorkAnalysisBilling.Months;

but would like to show dates next to Service and SubService.
Any help would be appreciated.
 
K

KARL DEWEY

Try putting the sum in header or footer of report and details only in query
output.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
Creating a Chart on form from selected data in query. 0
Remaining Balance Query 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Group By problem 2
Date query allowing user to enter dates 1
summing hours in a query 9
find duplicate records 5

Top