Sub-total Help

[DJohns]

I would like to do a sub-total on tickets sold by the date they were sold. What formula do I use?

[apr pillai]

Create a Total Query like the sample given below to prepare a Date-wise Summary:

SELECT Table1.SaleDate,
 Sum(Table1.SaleAmt) AS SumOfSaleAmt
FROM Table1
GROUP BY Table1.SaleDate;

[RayMilhon]

I would add to that by the following

Select Table1.SaleDate, Count(Table1.ID),Sum(Table1.SaleAMT)
From Table1
Group By Table1.SaleDate;

That way you get the total Sales Count and Total Dollar Amount By Date