totaling form

  • Thread starter Thread starter jomara via AccessMonster.com
  • Start date Start date
J

jomara via AccessMonster.com

I have a database that i didnt write that has log on security enabled (user
name and password) Each salesperson can only see their clients. Each contact
has a subform that they enter their sales on at this point the sales arent
totaled. I want to show their total sales for the month on the main form.
So far i have been able to show the total sales per client on their subform
but not a running total on the main form for all their clients. next problem
i am having is I want this to be a monthly total of their sales and
automaticly reset at the close of the month which is typicly 5 business days
after the end of the month. In the subform i do have an auto date field for
the day the sale is entered and a open date field for them to enter the sale
date
 
For your first issue, see if this tutorial is helpful to you:

Displaying Subtotals and a Grand Total on a Form That
Displays a One-to-Many Relationship
http://www.access.qbuilt.com/html/subtotals.html
next problem i am having is I want this to be a monthly total of their sales and
automaticly reset at the close of the month which is typically 5 business days
after the end of the month.
Click to expand...

I'm not sure I quite understand, but it sounds like you might need to use
the domain aggregrate function DSum, with the appropriate criteria. Something
like this, in the control source of a textbox on your form:

=DSum("Expression", "Domain", "Criteria")

See this page for usage instructions on DLookup. DSum would be done in the
same way:

DLookup Usage Samples
http://www.mvps.org/access/general/gen0018.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top