Hello,
I've been studying up on Select Case statements, and just cannot wrap my head around it. I have many if, then, else statements I need to evaluate for billing purposes
Code:
If Not IsNull(Forms!account!Order.Form!EndDate) And IsNull(Forms!account!Order.Form!startDate) and Forms!account!Order.Form!Closed = -1 And Forms!account!UseMonthlyRate = -1 Then
MsgBox "there is an end date but no start date, and account qualifies"
End If
I also need to evaluate the number of days a piece of equipment has been out, and if it is greater than 24(based on the actualnumberofdays or last day of the month(LDOM). When I have more than 3 nested if statements, the msgbox doesn't fire.
Any direction will be greatly appreciated.