Showing Totals Over Time On Form

[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

 

[John Vinson]

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.

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]