Calculated Field

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a form which is used to create a new record in my application.

I need make a calculation for a field which is conditional on the status of another field, as follows:

Field 1 (Y/N) field: if true then Field B = Field C*0.25
If false then Field B = Field C*0.10

What would be the correct expression to set Field B’s Control Source property to?

Thanks

.

Relevant Pages

  • RE: calculating a price in a report
    ... On both reports and forms, the Control Source property of a control ... direct calculation or if it is complex, ... "JensC" wrote: ...
    (microsoft.public.access.reports)
  • Re: Help choosing a field from a script
    ... calculation. ... Also, is there a way to have FMP choose the fields itself, or do I ... the next script is Set Field without specifying the field name. ...
    (comp.databases.filemaker)
  • Re: perform calculations in access
    ... You are already using the control's Control Source property for performing the calculation, I understand; this is one use for this property, the other one is to bind it to a table field, but I'm afraid you can't do both! ... There are ways around this, by means of using an alternative method for either the calculation or, getting the value stored in the table; the latter would normally be less convenient. ... If you can calculate it in a form, you can also calculate it in a report, so no need to store, and no need to maintain if one of the two input fields changes. ... Not storing saves you both the trouble and the grief of compromised data integrity. ...
    (microsoft.public.access.forms)
  • Re: IF Then statement
    ... I have a field that holds a dollar amount that is either a monthly ... the yearly pay for any given employee. ... this calculation to land in a text box on a form. ... Set it's control source property to: ...
    (microsoft.public.access.formscoding)
  • Re: Calculated Field
    ... Many thanks for pointing out the error of my ways! ... Powderfinger wrote: ... I need make a calculation for a field which is conditional on the status ... What would be the correct expression to set Field B’s Control Source ...
    (microsoft.public.access.formscoding)