B
bb99
Guest
Hope I can describe this coherently. I have a report which is required to count the ocurrence of distinct combinations of 3 tables over a certain period of time input by the user.. The following arent the exact names .Table 1, Place, Table 2, ContactType, Table 3 ContactPerson. The three tables are all related to a larger table where the date is situated, by their idnumbers as Foreign keys. Groupiing on table 1, I need to count how many times for example a singular occurrence of a particular contacttype AND a particular contactperson at a particular place is stored.
Any ideas ? Thanks in advance.
Any ideas ? Thanks in advance.