Query assistance

  • Thread starter Thread starter Steve Z
  • Start date Start date
S

Steve Z

I have created a DB to use in a Powerball pool. I have on table for our
picks and one table for winning numbers. I would like to create a query that
would compare our picks against the winning numbers each day we play the
lottery and find the winners. I am not sure how to go about this. Any
thoughts?

Thanks,

Steve
 
I am not sure what you mean, and I think it would be complicated by the fact
that each pick in the winning numbers would need to be compared to 5 columns
in the ourpicks table. Does that make sense?

Steve
 
Back
Top