Re: SQL design/query question

2002-07-03 Thread Chris Griffin
late, I've not tested this code, and this is free > advice, > take it for what it's worth.) :) > > HTH, > =C+ > * > * Cal Evans > * The Virtual CIO > * http://www.calevans.com > * > > > -Original Message- > From: Chris Griffin [mailto:[EMAIL

SQL design/query question

2002-07-02 Thread Chris Griffin
If this is not the right list for this please direct me to the proper list. I have a table of name/address information. I need to keep track of a weekly event and if they participated or not. I thought I could have a table of dates and people record ids with just those that participated. The