I have a query constructed as follows to total $Refunds and #Refunds by month.
the Fields are:
Date By Month: Format$([TblRefunds].[Date],"mmmm")
Seq:Year([TblRefunds].[Date])*12+DatePart("m",[TblRefunds].[Date]-1
Group by Date By Month and Seq
Also, I selected Aggregate Sum selected for Amount$ from [TblRefunds][Amount]. If I delete the Amount field, the query works, but shows all records. All I want to show is the sum by month, and also, the count of refunds by month. The Code came from RICHIE in a previous post in AWF. I did not get to the Aggregate count part yet. Any help?
the Fields are:
Date By Month: Format$([TblRefunds].[Date],"mmmm")
Seq:Year([TblRefunds].[Date])*12+DatePart("m",[TblRefunds].[Date]-1
Group by Date By Month and Seq
Also, I selected Aggregate Sum selected for Amount$ from [TblRefunds][Amount]. If I delete the Amount field, the query works, but shows all records. All I want to show is the sum by month, and also, the count of refunds by month. The Code came from RICHIE in a previous post in AWF. I did not get to the Aggregate count part yet. Any help?
