Is it possible to create a report from a table or multiple queries that show every entry and non entry in a database????
What i am trying to do is as follows....
I have a database that has a table holding all my customer information and a table holding all the information regarding their enquiries. I want to produce a report that will show every customers activity. i.e all the enquiries that they have made but i also want the customers that have made no enquiries to appear in the report. That way i can identify customers that need to be contacted to find out why they are not making enquiries.
Can anyone give me an idea of how to do this?????
What i am trying to do is as follows....
I have a database that has a table holding all my customer information and a table holding all the information regarding their enquiries. I want to produce a report that will show every customers activity. i.e all the enquiries that they have made but i also want the customers that have made no enquiries to appear in the report. That way i can identify customers that need to be contacted to find out why they are not making enquiries.
Can anyone give me an idea of how to do this?????