>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?
Hi,
Try
SELECT Orders.date, SUM(Orders.total);
FROM cash!orders;
GROUP BY 1
INTO TABLE ted1.dbf && Maybe cursor better
Cetin