Parent w/ no children Query

hi there

Registered User.
Local time
Today, 13:55
Joined
Sep 5, 2002
Messages
171
hi everyone,

i have a little 2 table dbase that has one table listing people (tblpeople) and another table listing tests (tbltests). tblpeople has a one-to-many relationship with tbltests. the tests table list information about tests taken by the people with a TestDate field in it. i'd like to create a parameter query based on the TestDate field that lists people (parent) that didn't get tested (no child). i'm not sure how to set up the query. could someone help me with this.

thanks alot for any help.
 

Users who are viewing this thread

Back
Top Bottom