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?