I have two fields - RulerNumber and RulerPoint. There are 10 RulerNumbers and 10 RulerPoints on each RulerNumber. I want to let a user enter a range of RulerNumbers and then a Range for RulerPoints. Eg - From RulerNumber 4 RulerPoint 6 TO RulerNumber 6 RulerPoint 3.
My problem is that I cant just use between for RulerPoint because a ruler in the middle of the range will have all of its Points.
So I am thinking to have one criteria for All Rulers between To and From then another criteria if Ruler = To or From then only return RulerPoints on that one.