Access Query Help


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;

Open in new window

Sean RhudyPresidentAsked:
Who is Participating?
dqmqConnect With a Mentor Commented:

SELECT [Sale Associate].Associd, SalelineAssoc.SlDate, count(*) as SalesCount
FROM [Sale Associate] INNER JOIN SalelineAssoc 
ON [Sale Associate].ssSaleKey=SalelineAssoc.slSaleKey
GROUP BY [Sale Associate].Associd, SalelineAssoc.SlDate

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.