Sum by month query

G

GerryE

I have a table named tblQuotationDollars. The table has the following
columns Quote Number, Date Sent and Sell. I need to create a query that will
sum the sell by month (based on the date sent) where the quote number begins
with QQ in the Quote Number field. I need the query to show all months of
the year. Can anyone help?
 
S

Smartin

GerryE said:
I have a table named tblQuotationDollars. The table has the following
columns Quote Number, Date Sent and Sell. I need to create a query that will
sum the sell by month (based on the date sent) where the quote number begins
with QQ in the Quote Number field. I need the query to show all months of
the year. Can anyone help?
Click to expand...

Drag each of those three fields into your query. Right click somewhere
in the properties and select Totals. Each of the fields will default to
Group By. Change the Sell field to Sum.

Lastly, you need to make the date field roll up by month. There's more
than one way to do this; here's one: replace the date field name with
the following:

TheMonth: DateSerial(Year(DateSent),Month(DateSent),1)

Hope this helps!
 
Top