J
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
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