Filtering on Milepost

 

 Top  Previous  Next

 

Show all accidents that occurred between milepost 12 and milepost 15

 

1.        (mile_1 >= 12 )
2.        (mile_1 <= 15 )

 

Show all accidents that occurred between milepost 12 and milepost 15, but exclude those that happened AT milepost 12, 13, 14, and 15.

 

1.        ( mile_1 > 12 )
2.        ( mile_1 < 15 )
3.        ( mile_1 <> 13 )
4.        ( mile_1 <> 14 )

 

A single line version of this filter would be:

 

1.        ( mile_1 > 12 ) & (mile_1 < 15 ) & ( mile_1 <> 13 ) & ( mile_1 <> 14 )