I have a field called AppStatus with a combo box (NEW, REDET etc.) and another field name EligStatus with dropdown (ELIG, DENIED, REACT etc.)


Calculations for EligDays:
If NEW from AppStatus and ELIG from EligStatus is selected, then
EligDays = AppRec – EligDate
If NEW from AppStatus and DENIED from EligStatus is selected
EligDays = AppRec – EligDate (same calculation as above)
If NEW from AppStatus and REACT from EligStatus, then
EligDays = EligDate – Reassess
If REDET from AppSatus and ELIG from EligStatus is selected, then
EligDays = EligDate – RedetDue
If REDET from AppStatus and DENIED from EligStatus is selected, then
EligDays = EligDate – RedetDue (same as above)
If REDET from AppStatus and REACT from EligStatus is selected, then
EligDays = EligDate - Reassess

I put the following, can someone tell me if I’m doing it right?
Thanks

Select Case AppStatus.Value

Case “NEW”
If EligStatus.Value = “ELIG” OR EligStatus.Value = “DENIED” Then
EligDays.Value = DateDiff (“d”, [AppRec], [EligDate])
ElseIf EligStatus.Value = “REACTIVATE” Then
EligDays.Value = DateDiff (“d”, [EligDate], [Reassess])
End If
Case “REDETERM”
If EligStatus.Value = “ELIG” OR EligStatus.Value = “DENIED” Then
EligDays.Value = DateDiff (“d’, [RedetDue], [EligDate])
ElseIf EligStatus.Value = “REACTIVATE” Then
EligDays.Value = DateDiff (“d”, [EligDate], [Reassess])
End If
Case Else
EligDays.Value = “”
End Select