copying a calculated value to a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've messed with this for a while and can't get it to work. I have a textbox
that is multiplied by either 1 or 12 depending on a selection from a
combobox, and that value is displayed in another textbox. that works fine
with the expression:
=Val(Nz([incVAIncome],0))*[cmbMonthlyAnnual1]
in the Control Source property of the second textbox. What I need now is for
that calculated value to be copied onto a report. Any suggetions?
 
Robert,
If the form is still open at report time, you can directly refer to the calculated
value...
= Forms!YourFormName!YourCalcFieldName
Or, create a calculated column in your query...
(assuming [incVAIncome] and [cmbMonthlyAnnual1] are bound controls)
CalcAmt : Val(Nz([incVAIncome],0))*[cmbMonthlyAnnual1]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Storing calculated values in a field 15
Default value via dlookup doing a calculation instead giving the v 3
How can I search the recordset of a Combobox? 2
passing a value to a report 11
Userform Calculation 4
Saving the value of a Calculated Text Box 3
report getting records from a form without recalculating them 4
Scrabble Value calculation for Welsh words 0

Back
Top