O
office drone
I'm working with an Access 2003 database that records users'
activities. There are two tables (related to this question): a USERS
table that records the users, and an ACTIVITIES table which the users
record their activiteis in. The two tables are connected by the unique
user ids, USER_ID, of each user. I need to create a query that will
show me which users have NOT entered any activities. (ie a query that
shows the USER_IDs that are found in the USERS table, but not in the
ACTIVITIES table) Is there any way to do this, because I'm completely
stumped.
As well, in an ideal world I would be able to filter this down so that
it shows which users haven't entered activities for a specific
date/month... (there's a date field in every record in the ACTIVITIES
table)... But that would be an added perk!
If you can offer any advice or direction, it would be greatly
appreciated.
Thanks!
activities. There are two tables (related to this question): a USERS
table that records the users, and an ACTIVITIES table which the users
record their activiteis in. The two tables are connected by the unique
user ids, USER_ID, of each user. I need to create a query that will
show me which users have NOT entered any activities. (ie a query that
shows the USER_IDs that are found in the USERS table, but not in the
ACTIVITIES table) Is there any way to do this, because I'm completely
stumped.
As well, in an ideal world I would be able to filter this down so that
it shows which users haven't entered activities for a specific
date/month... (there's a date field in every record in the ACTIVITIES
table)... But that would be an added perk!
If you can offer any advice or direction, it would be greatly
appreciated.
Thanks!