Re: Complex Query Question

2001-09-04 Thread Adams, Bill TQO
Carl Schrader wrote: > Field Special 1 has a related field with a Start Date and another field > for End date. > Field Special 2 has a related field with a Start Date and another field > for End date. > Field Special 3 has a related field with a Start Date and another field > for End date. > IMN

Complex Query Question

2001-09-04 Thread Carl Schrader
This question involves table setup questions as much as it involves a query question. Bare with me, this seems hard to explain. I have a table that includes records with 3 (relevant to this conversation) fields (actually 9..more on that later). Each of those fields have 2 other related fields. i.