look-back thru historical MDB 4 no. combinations w/o re. 2 their o

[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!! (^_^)

 

[Andreas]

As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas

 

[Guest]

it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas

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!! (^_^)

 

[Andreas]

In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas

it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:

As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas

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!! (^_^)

 

[Guest]

please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas

it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:

As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:

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!! (^_^)

 

[Andreas]

It doesn't make it easier, just different.
But let's have a go.
I presume you have the form ready to go.
- Create a query in design view.
- Bring in the tables and appropriate fields.
- In the first criteria row, set criteria for the first possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- In the second criteria row, set criteria for the second possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- repeat this for all 6 combinations, you should end up with 6 criteria
rows.

Regards,
Andreas

please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)


:

In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas

it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:



As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:


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!! (^_^)

 

[Guest]

seriously, you must the most patient and nurturing woman in the world. much
different than that guy over in "General Questions."

i'll try your solutions and hopefully i can figure out where it all goes.
i'm just not that familiar with all aspects of ACCESS, but i'll get it one
day.

THANKS! (^_^)

It doesn't make it easier, just different.
But let's have a go.
I presume you have the form ready to go.
- Create a query in design view.
- Bring in the tables and appropriate fields.
- In the first criteria row, set criteria for the first possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- In the second criteria row, set criteria for the second possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- repeat this for all 6 combinations, you should end up with 6 criteria
rows.

Regards,
Andreas

please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)


:

In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas


voxorganum wrote:

it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:



As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:


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!! (^_^)

 

[Andreas]

So I am a woman now?
Wonder what my other half is going to say about that!

seriously, you must the most patient and nurturing woman in the world. much
different than that guy over in "General Questions."

i'll try your solutions and hopefully i can figure out where it all goes.
i'm just not that familiar with all aspects of ACCESS, but i'll get it one
day.

THANKS! (^_^)

:

It doesn't make it easier, just different.
But let's have a go.
I presume you have the form ready to go.
- Create a query in design view.
- Bring in the tables and appropriate fields.
- In the first criteria row, set criteria for the first possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- In the second criteria row, set criteria for the second possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- repeat this for all 6 combinations, you should end up with 6 criteria
rows.

Regards,
Andreas

please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)


:



In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas


voxorganum wrote:


it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:




As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:



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!! (^_^)

 

[Guest]

Sir, i sincerely and genuinely apologize.

that was ignorance regarding your name's gender origin on my part.

please accept my apology.

still, THANKS for being patient and nurturing with my pleas for help with
the ACCESS problem. (^_^)

So I am a woman now?
Wonder what my other half is going to say about that!

seriously, you must the most patient and nurturing woman in the world. much
different than that guy over in "General Questions."

i'll try your solutions and hopefully i can figure out where it all goes.
i'm just not that familiar with all aspects of ACCESS, but i'll get it one
day.

THANKS! (^_^)

:

It doesn't make it easier, just different.
But let's have a go.
I presume you have the form ready to go.
- Create a query in design view.
- Bring in the tables and appropriate fields.
- In the first criteria row, set criteria for the first possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- In the second criteria row, set criteria for the second possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- repeat this for all 6 combinations, you should end up with 6 criteria
rows.

Regards,
Andreas


voxorganum wrote:

please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)


:



In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas


voxorganum wrote:


it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:




As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:



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!! (^_^)

 

[Andreas]

Don't worry about it, could have happened to anyone (and does from time
to time). After all, it is only a single character that seperates me
from womanhood, and even then it depends on the country of origin.

Regards,
Andreas

Sir, i sincerely and genuinely apologize.

that was ignorance regarding your name's gender origin on my part.

please accept my apology.

still, THANKS for being patient and nurturing with my pleas for help with
the ACCESS problem. (^_^)

:

So I am a woman now?
Wonder what my other half is going to say about that!

seriously, you must the most patient and nurturing woman in the world. much
different than that guy over in "General Questions."

i'll try your solutions and hopefully i can figure out where it all goes.
i'm just not that familiar with all aspects of ACCESS, but i'll get it one
day.

THANKS! (^_^)

:



It doesn't make it easier, just different.
But let's have a go.
I presume you have the form ready to go.
- Create a query in design view.
- Bring in the tables and appropriate fields.
- In the first criteria row, set criteria for the first possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- In the second criteria row, set criteria for the second possible
combination of the 3 numbers:
in the column containing the first number, place the criteria to point
to the field on the form where you enter the second number.
in the column containing the second number, place the criteria to point
to the field on the form where you enter the first number.
in the column containing the third number, place the criteria to point
to the field on the form where you enter the third number.
- repeat this for all 6 combinations, you should end up with 6 criteria
rows.

Regards,
Andreas


voxorganum wrote:


please note that i DO have the combinations broken down into separate columns.

one column for each of the three drawn numbers.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)


:




In the query, you need to make 3 substitutions.
"Field" should refer to the column that has all 3 numbers in it.

Did you save the form with the name "frmFind" (without the quotes)?

Did you change the "Name" property of the 3 text boxes?

Regards,
Andreas


voxorganum wrote:



it didn't work, and i'm almost positive that my esoteric knowledge of
database regulations is the culprit.

please note that i DO have the combinations broken down into separate
columns. one column for each of the three draw tube positions: a, b, or c
AND i also have the combination grouped in a single column together.

please reply and let me know if this information makes a less complicated
solution coalesce.

THANKS for any help!! (^_^)

:





As per my previous answer:

1)
- Create a new query and go to the SQL view
- Delete everything that may be showing
- Paste the following statement
(substitute your table name for

, substitute your field name
containing the draw result for [Field], substitute the field name
containing the draw date for [Date]):

SELECT * FROM

WHERE [Field] = (Forms!frmFind!txtN1 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN1 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN3) OR (Forms!frmFind!txtN2 &
Forms!frmFind!txtN3 & Forms!frmFind!txtN1) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN1 & Forms!frmFind!txtN2) OR (Forms!frmFind!txtN3 &
Forms!frmFind!txtN2 & Forms!frmFind!txtN1) ORDER BY [Date] DESC;

2)
- Create a form
- Place 3 texboxes on it
- Name them as txtN1, txtN2, txtN3
- Place a command button the form that runs your query (you can use the
wizard for that)

You are ready to go.
Type each individual number in the individual textboxes and press the
button.

Regards,
Andreas


voxorganum wrote:




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!! (^_^)