Name error but only if first report run?

[Sheila D]

Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila

 

[KARL DEWEY]

The problem is with [Total]. Redo the calculation instead of using
[Total].

 

[Sheila D]

Hi Karl

Thanks for your reply. I don't understand why I need to redo the calculation
as it works fine if I open any other report first. Total counts the number of
records; I don't think I can do this in the Page Header can I? Can you
explain a little more for me please.
Sheila

The problem is with [Total]. Redo the calculation instead of using
[Total].
--
KARL DEWEY
Build a little - Test a little

Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila

 

[KARL DEWEY]

Access looks to the Record Source for variables and your [Total] is not there.
--
KARL DEWEY
Build a little - Test a little

Hi Karl

Thanks for your reply. I don't understand why I need to redo the calculation
as it works fine if I open any other report first. Total counts the number of
records; I don't think I can do this in the Page Header can I? Can you
explain a little more for me please.
Sheila

The problem is with [Total]. Redo the calculation instead of using
[Total].
--
KARL DEWEY
Build a little - Test a little

Using Access 2007 - I have a report with a Text Box in the Page Header with
the Control Source =[Electrician] & ":" & [Total] & " Jobs for " & [Date of
Job]
Electrician and Date of Job are fields in the Data Source and Total is a
calculated field in the report header with the Visible property set to No.

If I run this report FIRST after opening the database this results in a Name
error but if I subsequently run any other report then the correct value shows
in the report and the error disappears. Anybody got any idea what could be
causing this.....
Thanks, Sheila