This query looks right to me. Are you sure the numbers are wrong? Could you be including deleted records or other records that should be filtered out? Could there be a few large erroneous values throwing off your totals?
>I have a simple query question. I know that I've done this before, but for the life of me I can't remember. I must have a brain cloud today.
>
>Table with two fields to be included in the query output: Date, Amount
>Hundreds of transactions for each day.
>
>I want to do a query with the end result being the total amount for each date.
>My first crack at this was to create a query grouping the Date field and having the expression sum(amount). This gave me numbers that were way out of whack.
>
>Here is the SQL from the existing query:
>
>SELECT Orders.date, SUM(Orders.total);
> FROM cash!orders;
> GROUP BY Orders.date;
> ORDER BY Orders.date;
> INTO TABLE ted1.dbf
>
>What am I missing?