Hello,
I have a calculation issue that I have not figured out how to do. Basically: "In how many records does a specific value appear in another table"? Here is an example how I would use it:
Table: tblPersons
Fields: Name (Primary key), BirthDate, WorkerID,
John, 20.02.1950, 12345
Fred, 21.02.1951, 12346
Mike, 23.02.1952, 12347
Larry, 24.02.1955, 12348
Paul, 24.02.1944, 12349
Table: tblPlaces
Fields: Place (Primary key), HostName
Warehouse, John
Factory, John
Factory2, Fred
Cafe, Mike
Shop, Paul
I'd need to create a counting field to a query and the query would look like this:
Query
Fields: tblPersons.[Name], "HostingTotallyPlaces"
John, 2
Fred, 1
Mike, 1
Larry, 0
Paul, 1
Any ideas how to solve this? I tried to work with SQL Count command but it didn't solve the issue completely. Thanks in advance!