Txtbox controls on report that call functions

  • Thread starter Thread starter Stephen
  • Start date Start date
S

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?
 
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
 
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?
Click to expand...


.
Click to expand...
 
Stephen;

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

Andy

Stephen said:
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?
Click to expand...


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