C
ChuckW
Hi,
I have a table with fields such as Customer, TxnDate, and
Quantity. What I want to do is to write a query that
will calculate the sales per month. I am thinking there
must be a function that will convert my TxnDate value to
a month. So a value of 4/15/04 would be converted to
April 2004. Is there a function that will do this?
After that, I can then run another query which will sum
the quantity sold by month for my customers.
Can anyone help?
Thanks,
Chuck
I have a table with fields such as Customer, TxnDate, and
Quantity. What I want to do is to write a query that
will calculate the sales per month. I am thinking there
must be a function that will convert my TxnDate value to
a month. So a value of 4/15/04 would be converted to
April 2004. Is there a function that will do this?
After that, I can then run another query which will sum
the quantity sold by month for my customers.
Can anyone help?
Thanks,
Chuck