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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying subtotals on Access forms

Status
Not open for further replies.

roverturf

Programmer
Sep 29, 2002
4
US
It's easy to show subtotals on Access reports, but is there a way to do the same sort of subtotals on an Access form?
 
You are going to have to give us more information that just his general question. SubTotals of what? Do you have a subform and what some type of Totals rollup? Please get back with more details and we can help.

Bob Scriver
 
I am looking for a method to subtotal a currency format column on a form. I need a group-by method, and then subtotal the currency values, much like can be done on an Access report. For example, column 1 is part number, column 2 is part quantity, and column 3 is part cost. I need a group on part number, and subtotal part quanity and part cost for that part number group. It's easy to do on a report, but I must be overlooking something simple to be able to do the same thing with a form.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top