Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unanswered: Multiple Related Ranges in Query

    Hi All,


    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.

    Any help would be much appreciated.

    Thanks!

  2. #2
    Join Date
    Apr 2011
    Posts
    2
    Hi All,

    Don't worry I have fixed it myself.

    Ended up just putting it all in the criteria.

    I just got any Ruler that was in the middle of a range and allowed all points, then got the two end rulers and only allowed the certain points.

    Pretty messy but works. If anyone is interested to know more please message me.

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •