Adding value to table based on a value in table

JahJr

Andy
Local time
Today, 07:01
Joined
Dec 3, 2008
Messages
93
I have 2 toggle buttons on a form that return a value of 1 or 2 to a table. I have another column in the table that needs to have 10% if 1 or 20% if 2. I have tried writing if statements in the expression builder but i cant seem to make it work. The column that the value from the toggle is returned to is named JValue the other column is named J%. The table is named Log. I know this is proably something simple but i cant figure it out. Help please.
 
Last edited:
If a field in a table always has a value based on another field in the same record then you do not need the additional field.
 
I am a newbie with access. I would agree i dont need the extra column but how do i get the toggle to post 10% instead of 1.
 
Do it in a query. IIF([1stField] = 1,.1,.2) As PercentField
 

Users who are viewing this thread

Back
Top Bottom