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

Update header record with Subform info

Status
Not open for further replies.
jasonstewart

jasonstewart

Programmer
Mar 14, 2002
39
US
I have a report that I want to update the Page Footer with the totals from a sub report in the body of the report. The column in the sub report is OrderDetails.Totals and I want the Order.Total to reflect the totals from all OrderDetails.Totals is there anyway of displaying this information? On top of that, is there a way of putting that into the Order.Total column in my table?
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
844
strongm
strongm
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
765
dhookom
dhookom
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
776
JimStrand
JimStrand
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
865
serino
serino
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
470
serino
serino

Part and Inventory Search

Sponsor

Back
Top