Hello, I'm trying to create a query that pulls from two tables, which is pretty straight forward.
The first five fields are from ContributorInfoT. The next fields will be from ACEObservationT. In My ACEObservationT Table, I have a field called DayOfMonth, which records the date each time a record is entered.
For my query, I'd like to have 12 additional fields, one for each month, and then I would like each of those fields to count the number of times each month is entered, per person (each person is represented in a field called ACEObserverID). I simply have no idea to customize those 12 fields to count occurrences.