Hi everyone, I have two tables setup in my access database. The first one is a case history table. It lists such columns as Case #, Aging Parents (Yes/No), Energy (Yes/No) and etc.
I then have another table that is a log of the activity that has occurred for each case. Some cases can have multiple entries.
When I go to create a query that will sum the number of Aging Parents cases, if there are multiple entries in my case table it will count the same case multiple times for one category- when in all reality it's just the same case. Does anyone know how I can sum each column based on each case number and not each entry in my log table?
There is a join between my data table and log table, it's joined by the Case #.