Hi Jill.
>When I do a report on names in People Date Issued and filter on EMPTY Date Arrested all works fine. WHen I add the Case Number it blows up w/the 'Too many subqueries' error. It doesn't seem THAT involved to me!
You're right -- that doesn't seem like a complicated query. However, it could be that the join SFReports is trying to do isn't quite right, so it makes it more complicated than it should be.
Do the following: after the error occurs, go to the Command window and type: MESSAGEBOX(_screen.ActiveForm.oQuery.cSQLSelect). That'll display the SQL SELECT statements SFReports was trying to use. Do the join conditions there look correct? If so, then there must be some environmental thing going on. If not, then take a look at the relationships you've defined between your tables. Maybe there's a circular relationship somewhere that causes SFReports to make the join too complex.
Doug
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement