Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

make report to sum by field

Status
Not open for further replies.

KimVong

IS-IT--Management
Sep 13, 2002
90
US
I made a report to run under the form, if user enter January, it will show a report with summary of by description field, units sold, sold, gross profit for january/2003, and january/2003. It's looks great when user just enter january, february.


Problem Here:
I need the same report format, but this time, if user enter, january, february, and etc, I want to make this new report show the year to date, not month to month.
what should I do to make this new report show up year to date, meaning, if user enter February, we will add total of units sold, sold, gross profit from january plus february, and if march they enter, it would be january + february + march.....
can someone hint me this?
thanks

Kim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top