asked on

Calculated Field - in table?

Experts,

i need to build a table of Commissions.
The commission amount is a calculated field.
I dont believe I can put the calculated amount in the table.

But how can I put that same amount on a report?
Do I have to also calculate that commission on the report as well?
I would prefer for that calculated commission amount to be in the table
Any quidance will help.
I dont know the recommended practice.

thanks

ASKER CERTIFIED SOLUTION

lee555J5

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

OK so I see that typically you dont save calculated fields in a table...usually it is done in a function.

thank you

lee555J5

Right. If it's a function, you only need to create the calculation once, but you can use it anywhere you need it. Also, if you need to change the calculation, you only need to change it once.

MINDSUPERB

Are you using Access 2010?

Ed

SOLUTION

als315

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

Ok.... Thanks. I am using 2007. Had internet issues.... The calculation is very simple: amount * rate.

mbizup

If those two values are in the reports underlying recordsource, you can set the control source property of a textbox as follows (include the = sign):

= [amount] * [Rate]

If they are not in the report's recordsource, where/how should they be 'looked up'?

SOLUTION

lee555J5

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial