Accessing control that sums in header of subreport

C

Chips

I've got a control [HrsMult] in the header of a subreport that calculates
the hours to multiply wage by.

It multiplies regular hours by 1, time and a half hours by 1.5, etc, and
adds them all up.

So 40 regular hours plus 2.5 hours at time and a half comes to 43.75 hours.
This I multiply by the basic wage and get the weeks wages for the guy.

I'm trying to put this amount in the detail portion of the next report up
(it's parent report) and I can't get it to show it.

I've tried a few variations of:

Reports![Orders]![Orders SbRpt].Report![Quantity]

and can't get it to grab the data out of the control in the subform. I get
the name# error.

Any suggestions?

I'm using Access 2003, but the file is Access 2000 and I'm keeping it that
way. It's running in WinXP Pro.

GC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding regular and overtime hours and multiplying by rate 1
Accessing Subreports Group Section Totals in Parent Report Header 1
Subreport parent reference 10
subreport/report total question 5
Sum of calculated field from a query 2
Sorting based on a max function in a subreport (in Access 2003) 3
Group Header doubling on first page 1
Trying to Count 3

Top