denniston wrote:Wow that's disappointing. Two years to limp along is a long time.
The problem is that they're moving from a Foxpro based system to something completely new, but maintain the same functionality, look and ease-of-use. It would be child's play for a company the size of Intuit, however, Powerchurch is not that large a company, so the people working on the new version, are the same ones who have to maintain the old version.
Then imagine the kind of testing that will need to be done to insure that the new version, when released, does not introduce new bugs.
In your case, have you tried this:
All members should be in an activity called Worship (100), using that as your main source, you can then say something like:
Pseudocode of course:
Select all from Activities where
Activity Number = 100
and not in (select all from activity where activity number > 7200 and < 7400)
Considering the complexity of this code, you may need to export the data to Access tables, and create the query there. Yes, its another step, but for the time being, it may be the easiest way to do it.