Trevor G
Well-known Member
- Joined
- Jul 17, 2008
- Messages
- 6,847
- Office Version
- 365
- Platform
- Windows
I am seeking to use a module sheet to create a sub/function to update a field if it meets certain criteria
I have a table called = "GDV_Rates_Conventional_Sum"
and I have a fields called "N
f_Risks_Sum"
What I need to do is fill a field if the following occurs
number of N
f_Risks_Sum is above 100 Then place in 1
number of N
f_Risks_Sum is Between 50 and 100 Then place in 2
number of N
f_Risks_Sum is Below 50 Then place in 3
The field to update is called Credibility
Any example would be greatly appreciated
I have a table called = "GDV_Rates_Conventional_Sum"
and I have a fields called "N

What I need to do is fill a field if the following occurs
number of N

number of N

number of N

The field to update is called Credibility
Any example would be greatly appreciated