G
Guest
hi. i'd like to know how to do a "find" for records in a single column with a
number combination,
example: "123" which could be in any order.
so i'd be finding any record in a column containing: 123, 132, 213, 231,
312, or 321 without having to enter each different combination.
i'll try to explain as best i can.
first, this is about "Cash 3" of the Florida lottery: www.flalottery.com
i'm just trying to find draw-history patterns of the 3-number combinations
which can have same digits and can be any combination/order, 0-9.
so i was hoping to do "look-backs" in the history of the drawings to find
3-number combination frequencies without regard to their order as they're
drawn.
so i need to be able to "look-back" through the draw dates and find
occurences of 3-number combinations.
for example: recently, 479 was drawn. i want to look back and see when the
last time it was that 479 was drawn WITHOUT regard to the order that 479 was
drawn the last time it was drawn. it could be 974 or 497 or whichever.
i wish there was some way i could just click on the binoculars on the menu
above my table/draw-history, and make some instruction for the "FIND" along
with "479" and have Access return the last date or all the dates that 479 was
drawn WITHOUT regard to the order those three numbers were drawn.
i hope this makes things easier to understand. THANKS for any help!! (^_^)
number combination,
example: "123" which could be in any order.
so i'd be finding any record in a column containing: 123, 132, 213, 231,
312, or 321 without having to enter each different combination.
i'll try to explain as best i can.
first, this is about "Cash 3" of the Florida lottery: www.flalottery.com
i'm just trying to find draw-history patterns of the 3-number combinations
which can have same digits and can be any combination/order, 0-9.
so i was hoping to do "look-backs" in the history of the drawings to find
3-number combination frequencies without regard to their order as they're
drawn.
so i need to be able to "look-back" through the draw dates and find
occurences of 3-number combinations.
for example: recently, 479 was drawn. i want to look back and see when the
last time it was that 479 was drawn WITHOUT regard to the order that 479 was
drawn the last time it was drawn. it could be 974 or 497 or whichever.
i wish there was some way i could just click on the binoculars on the menu
above my table/draw-history, and make some instruction for the "FIND" along
with "479" and have Access return the last date or all the dates that 479 was
drawn WITHOUT regard to the order those three numbers were drawn.
i hope this makes things easier to understand. THANKS for any help!! (^_^)