I can't for the life of me figure out how to insert a field base on multiple
conditions. What I'd like to do, for instance, is something like this:

If Amount = 50 And Amount =100 Then "The amount is between 50 and 100"

Can anyone help?

Stephen