Access Power Ball and Mega Millions lottery DB. It will let you enter the draw numbers and your pick numbers, then do a match analysis to show your results.
I found a lot of Excel solutions on-line for this, but nothing for Access, so I took it on, and here's the results.
If you want to do historical analysis, the Mega Millions history goes back to mid 2002, and the Power Ball back to 2010.
The first few records shown in the forms are test picks to demonstrate the program. You can delete all the data from the two tblMYMMpicks and tblMyPBpicks to get a fresh start or just overwrite with you own picks...
I haven't played much lotto, so I don't know how useful this might be to a dedicated player. I'll entertain suggestions for enhancements. To find revisions, always scroll down the thread. If bugs found, report them here and I'll do my best to correct the code. Fixing bugs will take precedence over providing enhancements.
Use at your own risk. The author assumes no responsibility for errors that might cause a user to miss a winning pick. Always manually check your tickets against the official draw numbers.
Lottery-davegri-v01.zip