Need a Filter in my Lotto Machine Form.

I wanted to add a filter to the lotto machine that will allow me to just see one day a week.  so i get match results and I can put in Tuesday and it only shows me Tuesdays.  It would work with the match filter or without.  And of course for reporting, it would dump into the tempResults table.

I'm not sure how difficult this is.

Let me know, any direction would be great!!


This is the database:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Compact and repair is a happy thing.
I pulled down the 256 MB sample.
Compacted it.
1.5 MB

Now, on frmFilter you want to optionally select a weekday so that you can look for draws where certain numbers came up on certain days of the week?
Like this?
Done on your main form.
Changes to the form, the query and tempTable

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bdgbrickAuthor Commented:
Thats exactly what I want, however, it doesn't seem to be filtering out the days not chosen?? Im not sure if I am doing it wrong?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

I only played with it a little.
But if I picked 7-9-13-16 and match = 4 on Wednesday and hit Requery/Save, I get Draw 1757719
All days, there are 46
Sundays --4
Mondays -- 11
Tuesdays -- 8
Wednesday -- 1
Thursday -- 2
Friday -- 7
Saturday --13

Match is mandatory -- it doesn't create a filter without it.
Does it need to be optional?

This one will deal with an invalid match value and still filter by day
bdgbrickAuthor Commented:
I would like it to be optional, unless its a huge Pain, that isn't crucial. Im going to use it almost exclusively with match.
This really a first step in what I want as far as Excel charts.

This is obviously another question, but I want your opinion on how difficult this would be. I would pay money for this functionality!!!

I loaded you a sample of what I have been doing with the data Manually.

Im not sure if a form could be built and launched from the main form that would take my match for a single day and Line chart the draws Between.

  Almost like a split form with a Customer at the top and orders at the data-set bottom.

Mine would be a date at the top and all the 5 matches for that day on the bottom, and a line Graph plotting the draws between each match for that single day. As you move through the days the data and graph on the bottom would change. That seems to me like a ton of code.
bdgbrickAuthor Commented:
Nick Is the best!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.