If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab query?
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 |
#2
|
|||
|
|||
Crosstab query?
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; -- KARL DEWEY Build a little - Test a little "Question Boy" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|