Query Selecting From Itself?!?!?

Peter Mckay

i'm looking at a query that was created by my predecessor called Top 100 Donors.  It is a blank query, no criteria, except for under Query Options > Record Processing > Select From Query  there is a query called Top 100 Donors.  I am 90% sure it's the same query.  Is this possible?  Chicken or the egg?!??!

 

Thanks :-)

JoAnn Strommen

Peter Mckay:

i'm looking at a query that was created by my predecessor called Top 100 Donors.  It is a blank query, no criteria, except for under Query Options > Record Processing > Select From Query  there is a query called Top 100 Donors.  I am 90% sure it's the same query.  Is this possible?  Chicken or the egg?!??!

 

Thanks :-)

To me 'no criteria' means it's an output query that came from a report.  I'm guessing Reports > Analytical Reports > Top Donors Report.  Am guessing your predecessor had it generate the top 100.  Check there for a report. 

Peter Mckay

JoAnn Strommen:

To me 'no criteria' means it's an output query that came from a report.  I'm guessing Reports > Analytical Reports > Top Donors Report.  Am guessing your predecessor had it generate the top 100.  Check there for a report. 

That makes sense. Thanks Joanne