In a query, I'm trying to count the number of occurences of a field in the query in another table. So, my query has two tables and one of the columns is [Initials]. I'm trying to look in another table, T_Initials (SHARED), for the number of times the value in Initials occurs in the column/field with the same name.
I know the syntax, but it seems I only need two parameters: the table I'm looking in..and the criteria, in this case: [Initials](from the other table)=[T_Initials (SHARED)].[initials] (from the current query)
Can someone help me with this expressions