I have a table that has three columns. The first column is a Date (in short date format, the second column is a contact type. There are 7 different contact types (Home visit, Hospital visit, phone call, etc) I want to enter a record that records each contact I have. That record will include a name, and possibly a note. On a separate sheet I want count all of my contacts, by type, to create a monthly report. Because there could be as many as a hundred entries a month, I want to be able to specify the month I want to generate the report for.
In other words, if I am doing a report for July, I want to count the number of contacts I had in July by type. But I only want the report show the contact data for July. Does that make sense
Fred H Chapman