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!

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

I have a report that I export to ex

Status
Not open for further replies.
kpalazzi

kpalazzi

Technical User
May 2, 2000
35
US
I have a report that I export to excel. It groups rows by Field1. The query the report is based on subtotals the value of each field1 group.

My report looks like this

field1 Value Subtotal
aaa 2.00 6.00
aaa 2.00
aaa 2.00

bbb 1.00 2.00
bbb 1.00

I need the subtotal to show at the last row in the field1 group instead of the first row. How can I do this?

An access solution is preferable, but I will take an Excel macro or vba solution. Thanks
Kimberly Palazzi
kpal29@hotmail.com
 
Status
Not open for further replies.

Similar threads

telephoto
  • Locked
  • Question
Report waiting for printer before displaying results 1
Replies
3
Views
364
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
854
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
1K
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
810
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
4K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top