Search results

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))...