Txtbox controls on report that call functions

[Stephen]

Hi All,

I've got a TxtBox on a report. The Control source calls a
function in a module. I have had to create the function in
a module as it is an Excel function not provided in access.
The Txtbox control contains
MyResult:SigX([TxtTotalErrors],[TxtTotalUserTotal])
'SigX is the function,
'TxtTotalErrors is a txt box containing totals
'TxtTotalUserTotal is a txt box containing totals
This would/does work in a query, but I need it on a report
as I'm totaling many records.

Can anyone help? Is this a report issue, or should it
work OK?

 

[Andy]

Stephen;

Not sure if this is your answer but we'll try.

I too could not get the txtControls to Total.

Someone posted simply this:
You total the Field name not the name of the Control.

Meaning:
=Sum(txtItemsSold) didn't work.
Where txtItemsSold was the name of the Control in the Report.

=Sum(ItemsSold) worked.
Where ItemsSold was the name of the field in the Table that is bound to the
Report.

Andy

 

[Stephen]

Cheers Andy, but the txtboxes are not fields in my
tables. They are also calculated fields based on fields
in my tables.

Stephen

-----Original Message-----
Stephen;

Not sure if this is your answer but we'll try.

I too could not get the txtControls to Total.

Someone posted simply this:
You total the Field name not the name of the Control.

Meaning:
=Sum(txtItemsSold) didn't work.
Where txtItemsSold was the name of the Control in the Report.

=Sum(ItemsSold) worked.
Where ItemsSold was the name of the field in the Table that is bound to the
Report.

Andy

Hi All,

I've got a TxtBox on a report. The Control source calls a
function in a module. I have had to create the function in
a module as it is an Excel function not provided in access.
The Txtbox control contains
MyResult:SigX([TxtTotalErrors],[TxtTotalUserTotal])
'SigX is the function,
'TxtTotalErrors is a txt box containing totals
'TxtTotalUserTotal is a txt box containing totals
This would/does work in a query, but I need it on a report
as I'm totaling many records.

Can anyone help? Is this a report issue, or should it
work OK?

.

 

[Andy]

Stephen;

Wish I could help You more; haven't tackled anything like that YET.

Andy

Cheers Andy, but the txtboxes are not fields in my
tables. They are also calculated fields based on fields
in my tables.

Stephen

-----Original Message-----
Stephen;

Not sure if this is your answer but we'll try.

I too could not get the txtControls to Total.

Someone posted simply this:
You total the Field name not the name of the Control.

Meaning:
=Sum(txtItemsSold) didn't work.
Where txtItemsSold was the name of the Control in the Report.

=Sum(ItemsSold) worked.
Where ItemsSold was the name of the field in the Table that is bound to the
Report.

Andy

Hi All,

I've got a TxtBox on a report. The Control source calls a
function in a module. I have had to create the function in
a module as it is an Excel function not provided in access.
The Txtbox control contains
MyResult:SigX([TxtTotalErrors],[TxtTotalUserTotal])
'SigX is the function,
'TxtTotalErrors is a txt box containing totals
'TxtTotalUserTotal is a txt box containing totals
This would/does work in a query, but I need it on a report
as I'm totaling many records.

Can anyone help? Is this a report issue, or should it
work OK?

.

 

[Duane Hookom]

What is your exact Control Source property?
Is it
=SigX([TxtTotalErrors],[TxtTotalUserTotal])
Are the other text boxes in the same report section?