Experts please help me with a Query. It should be very simple but i have not worked with Access in quite a while so I am not doing something right.
I have two tables; Company and Contact.
Company table has two fields; [ID] and [CompanyName].
Contact table has three fields; [ID] and [CompanyID] and [ContactName]
I need the query to output all Company Names and a count of the number of contacts for that company.
Anything I do in the query builder gives me the following error.