I need to show all new students, incl. those that have siblings already in the school & I can't. I get only students of new families that were never in the school before.
I need to show all new students, incl. those that have siblings already in the school & I can't. I get only students of new families that were never in the school before.
Not enough info to offer advice.
Show the query SQL statement. If you want to provide file for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
FYI, I deleted your duplicate thread. Please don't post the same question twice.