total a query

[jomara via AccessMonster.com]

I have a query that lists a salespersons sales i need to have the total sales
show on their main form .
I have created a text box on the form but cant seem to figure out the
expression to get it to total the 1 column of sales. Also i would like the
totals to reset at the first of the month needing help with the datepart
here are the fields in the query
last name (of of customer)
sale date
item sold
price
quantity
total sale
this info comes from 2 tables and a query where the salesperson is the link

 

[Marshall Barton]

I have a query that lists a salespersons sales i need to have the total sales
show on their main form .
I have created a text box on the form but cant seem to figure out the
expression to get it to total the 1 column of sales. Also i would like the
totals to reset at the first of the month needing help with the datepart
here are the fields in the query
last name (of of customer)
sale date
item sold
price
quantity
total sale
this info comes from 2 tables and a query where the salesperson is the link

If the main form is bound to that query, then just use a
text box (in the form's header/footer section) with the
expression =Sum([Total Sale])