Access Query Help

Hello,

I have joined 2 tables using a query in access, that works fine.  Just for reference, the Associd refers to a specific sales person, ssSaleKey refers to a specific sales transaction, and ssShare is either 1 or 0.5 depending on if the sale was split between 2 Associd's.

This info will be used in a crystal report later.  I need a query that will tell me how many sales each associate had on each day, including the half shares.  The code below is the query that joins the 2 tables so I have all of the info in one place.  I need a query from the below query.

SELECT [Sale Associate].Associd, [Sale Associate].ssSaleKey, [Sale Associate].ssShare, SalelineAssoc.slSaleKey, SalelineAssoc.SlDate
FROM [Sale Associate] INNER JOIN SalelineAssoc ON [Sale Associate].ssSaleKey=SalelineAssoc.slSaleKey;

Select allOpen in new window