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