Crosstab query?

[Question Boy]

Hello I have 2 tables

1 Members
ID
FirstName
LastName

2. Stats
EntryDate
EntryType
ID -- From the Members Table
RefType
Amount

What I need help to do is create a query that give me the summary (count)
for each ID for Each type of EntryType (B, G, R). I can do this using
several queries but would like to know how this can be consolidated into one.

Thank you,

QB

 

[KARL DEWEY]

Try this --
TRANSFORM Count(Stats.EntryType) AS CountOfEntryType
SELECT [FirstName] & " " & [LastName] AS Name, Count(Stats.EntryType) AS
[Total Entries]
FROM Members INNER JOIN Stats ON Members.ID = Stats.ID
GROUP BY [FirstName] & " " & [LastName]
PIVOT Stats.EntryType;