I have attached an image of the example I am trying to explain.
Ok so I already have 2 tables set up, lets call them table 1 and table 2. I have different records that have 1 Primary key that are in relationship. But I have another Field "type" (see image) that I would like to find and count up each record in the 2 tables that have the similar field and do a count so I can see the count totals from each table (of how many types there are).
I mainly work out of design view, not very familiar with SQL. This seemed easy to do but when I began doing it I was unsuccessful.
I hope someone can assist me with this. Again I am access intermediate-ish, so an explanation that is simply would be greatly appreciated. Looking for finish this up for a report out to work this coming friday.
I hope the image attached helps out!!