Calculated field as a trigger

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

Guest

I would like to know how to trigger a Yes/No field to return a value of Yes
when the number in a calculated field is =>3. Thanking you in advance!
 
Thanks Karl,
I used the following expression in the control source of the yes.no text
field and it work just fine.
=IIf(([PeriodLastAnnoited]>2),"Yes","No")
 
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

Using a Yes/No field to trigger a calculation in another field - J 6
If "Yes" in check how do I show value and if "No" no value 1
Using a Yes/No field to trigger a calculation in another field - J 3
Is there a way to view a checkbox in my calculated query field? 3
Calculating averages on a form 3
Calculator 1
Calculated Fields in a Table 2
Event from Calculated Control 6

Back
Top