Need Advice - RecordSet or Array or Neither? Best Approach

From	mjbaz <mjb5555ca@yahoo.ca>
Newsgroups	comp.databases.ms-access
Subject	Need Advice - RecordSet or Array or Neither? Best Approach
Date	2011-03-31 06:34 -0700
Organization	http://groups.google.com
Message-ID	<cb80add5-1522-4467-83a3-af4693ecf800@r4g2000vbq.googlegroups.com> (permalink)

Show all headers | View raw

Hello Everyone:

I am trying to create a lottery checking program in Access 2007 (just
so I can practice my rusty skills).  What would be the best approach
to comparing two sets of numbers?  The user will enter their ticket
numbers (6 per record) in one table  and then enter the Winning
numbers (7 per record) in another table. There is a relationship
between the the two tables based on the date of the draw.

What would be the best approach to loop through the ticket numbers and
flag those numbers that match the winning numbers?

Appreciate any ideas.  Thanks in advance

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar

Thread

Need Advice - RecordSet or Array or Neither? Best Approach mjbaz <mjb5555ca@yahoo.ca> - 2011-03-31 06:34 -0700
  Re: Need Advice - RecordSet or Array or Neither? Best Approach Salad <salad@oilandvinegar.com> - 2011-03-31 09:18 -0500
    Re: Need Advice - RecordSet or Array or Neither? Best Approach mjbaz <mjb5555ca@yahoo.ca> - 2011-03-31 07:28 -0700
  Re: Need Advice - RecordSet or Array or Neither? Best Approach "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 09:41 -0500
    Re: Need Advice - RecordSet or Array or Neither? Best Approach mjbaz <mjb5555ca@yahoo.ca> - 2011-03-31 08:57 -0700
      Re: Need Advice - RecordSet or Array or Neither? Best Approach "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 11:16 -0500
        Re: Need Advice - RecordSet or Array or Neither? Best Approach mjbaz <mjb5555ca@yahoo.ca> - 2011-03-31 09:49 -0700

csiph-web