Showing Totals Over Time On Form

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I have an app where the user enters sales over time. What is the most
efficient way to display the current year and current month sales on each
form? That way the user has an idea of where they are as tehy enter each
sale.

Thanks

Joe
 
I have an app where the user enters sales over time. What is the most
efficient way to display the current year and current month sales on each
form? That way the user has an idea of where they are as tehy enter each
sale.
Click to expand...

Probably with a textbox with a Control Source such as

=DSum("[amount]", "[sales]", "<some criteria appropriate to your form
and your table which I cannot supply because I don't know what your
form or your table are like>")


John W. Vinson[MVP]
 
Back
Top