A
A Man
I want to make a query on an OrderDetail table that sums the sales for
year 2007 by customer. This query will be used to make a table, the
table will be used to make a report later on.
Anyway, the detail order table has the item number, qty ordered, and
BillDate. The year can be extracted using: Year: mid(str
([BillDate]),2,4).
I want each row to show one customer, and the sum of sales for the year
2007. Anyone know how to do this?
Thank you.
year 2007 by customer. This query will be used to make a table, the
table will be used to make a report later on.
Anyway, the detail order table has the item number, qty ordered, and
BillDate. The year can be extracted using: Year: mid(str
([BillDate]),2,4).
I want each row to show one customer, and the sum of sales for the year
2007. Anyone know how to do this?
Thank you.