Report question

Question: SQL Select between two fields depending on the value of one field