Hi,
I'm developing a CRM (Customer Relationship Management) system in MS
Access. I have 2 tables. The first is a customer master file, the
second is an activity file.
A key function of the system will be to track when it is time to
follow up with a customer. Sometimes it's for a specific reason, other
times it's just a routine "keep in touch" contact.
In the activity file, there is a True/False field where when the field
is true, the follow up activity is complete.
My challenge is that the user might sometimes forget to create a
follow up activity. Just scrolling through the file, it's easy to see
when this happens - the customer master record has no activity file
record that is not marked complete. With a lot of customers however,
one might get missed.
I want to query the database and present the user with a list of
customers that don't have an open activity record. It seems like I
need an "EXCEPTION JOIN" but I don't see any such functionality. How
would I create a query that would tell me what customers don't have a
"False" activity complete flag record?
Thank You!
Paul