Recent content by Sullster47
-
S
VBA If statement to see if time is between 2 paramters
Thank you to all that have replied. Yes, you are correct in that the statement doesn't make literal sense. I have turned it round as per the answers and it now works. Great to have the help put there. All the best J- Sullster47
- Post #7
- Forum: Modules & VBA
-
S
VBA If statement to see if time is between 2 paramters
I have an if statement where i need to see if the time of a field is between 8pm and 6 am. If it is, we have a different rate but i can't get the if statement to work. i have: If me.txtTime < #5:59:00 AM# and me.txtTime > #7:59:00 PM# then me.txtrate.vale = CDbl(Nz(me.SatNightRate))...- Sullster47
- Thread
- Replies: 7
- Forum: Modules & VBA