Counting combinations of field entries

  • Thread starter Thread starter bb99
  • Start date Start date
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.
 
Use totals queries. Just select all the fields you want to group by and add a count field.
 

Users who are viewing this thread

Back
Top Bottom