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.
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.