If formula for 2 classes

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

Guest

I'm trying to work out how to do this nested if formula. I want to say

If [Student Start Date]<DAte() and [Student Start Date]+345>Date(),"Class 1"

the second part is

If [Student Leaving Date]>DAte() and [student leaving
date]-345<date(),"Class 2"

how do i put these into one if formula
 
Database said:
I'm trying to work out how to do this nested if formula. I want to say

If [Student Start Date]<DAte() and [Student Start Date]+345>Date(),"Class 1"

the second part is

If [Student Leaving Date]>DAte() and [student leaving
date]-345<date(),"Class 2"

how do i put these into one if formula
Click to expand...


IIf([Student Start Date] < Date() And [Student Start Date] +
345 > Date(), "Class 1", IIf([Student Leaving Date] > Date()
And [student leaving date] - 345 < Date(), "Class 2",
"???"))
 
Back
Top