Matching Numbers

[ChristineC]

Hi all,
I need to write a matching program that will match lottery numbers with a users selected numbers. The lottery numbers change twice a week and there will always only be one record in the results table. The data in the results table comes from a web page which has beEn parsed using VBA.
If anyone can help with this I would greatly appreciate it.

Thanks Christine

This is the layout of my tables

1st Table
Numbers Table:

SequenceNum 'Auto Number
LotDate
UserName
NumbersLine1 'holds first line entered by users (contains 6 numbers)
NumbersLine2 'holds 2nd line enterd by users
NumbersLine3
NumbersLine4
NumbersLine5
NumbersLine6

Users must enter in at least 2 rows of numbers.

2nd Table
Results Table: 'Hold details of a lottery draw

LotDate
Amount 'Jackpot amount
Num1 'holds 1st number drawn
Num2 'holds 2nd number drawn
Num3
Num4
Num5
Num6
Bonus 'holds bonus number drawn in the draw