Basicfarmer
asked on
Need Some Help With an Access Query
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER