Hi I am trying to add the field "Month to my query, I need to get total monthly sales for any given year and I don't know how to include the field "month" into the query.
Can anyone help?
Regards
Don
Hi I am trying to add the field "Month to my query, I need to get total monthly sales for any given year and I don't know how to include the field "month" into the query.
Can anyone help?
Regards
Don
What fields are in the Table you are trying to query? If we are to help you, you are going to have to provide some info and details of What you have and What you want as output.
I have "SalesPerson" "Sales" and "SalesDate" I need to be able to get the total monthly sales for each salesperson for any given year. So I need to have the Month displayed in the query along the " " " . Sorry I am very new at this.
in the query in design view; in a blank column add: SalesMonth: format([SalesDate],"m")
this will result in the numeric value of the month
forgot to add:
mmm will result in short text of month i.e. Dec
mmmm will show full month name
Here are a couple of links that you should also be familiar with.
SUM () http://www.w3schools.com/sql/sql_func_sum.asp
Group BY http://www.w3schools.com/sql/sql_groupby.asp
Good luck.
Thank you that worked well