I have two tables set up. One is a masterdatabase table and the other is a summary table.
The masterdatabase contains a field titled "YearMonth" which contains the year and month for each incident.
In the summary table I also have a "YearMonth" field as well as an "Number of incidences" field.
I want to create query which counts the number of incidences for each yearmonth.
I've tried the following expression without anyluck.
Expr1: Sum([masterdatabase.yearmonth]=[summarytable.yearmonth])
Any suggestions would be very helpful
The masterdatabase contains a field titled "YearMonth" which contains the year and month for each incident.
In the summary table I also have a "YearMonth" field as well as an "Number of incidences" field.
I want to create query which counts the number of incidences for each yearmonth.
I've tried the following expression without anyluck.
Expr1: Sum([masterdatabase.yearmonth]=[summarytable.yearmonth])
Any suggestions would be very helpful