Error on Report - Calculated Field

[CarlRostron]

I have a report and within the report is a subreport. Within the subreport I have an =sum([HoursRecorded]*24) and the Text Box label control is named 'SumHours'. The Subreport within the main form is named [subreportinvoice].

In the footer of the main form, I have the following:

=IIf(IsNull([ManuallySetPrice]),[HourlyRate]*[subreportInvoice].[SumHours],[ManuallySetPrice])

I get the error: #NAME?

Any ideas please?

 

[vbaInet]

You mentioned that the LABEL caption is called SumHours so how is that the name of the textbox? Isn't the Name of the textbox in the Name property of the Textbox's Property Sheet?

Eventually your code should look like this:

=Nz([ManuallySetPrice], [HourlyRate]*[subreportInvoice]![[COLOR=Red]NameOfTextbox[/COLOR]])

 

[CarlRostron]

Great, works fine. Thanks for your help.

 

[vbaInet]

You're welcome!