Re: How to summarize recordset...Select Distinct alternative?
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Tue, 13 Nov 2007 21:11:40 -0000
Why not
-- for items
SELECT FldFile, FldPage,FldItem, COUNT(FldItem)
FROM yourtable
GROUP BY FldFile, FldPage,FldItem
ORDER BY 1,2,3
-- for summaries
SELECT ,FldItem, COUNT(FldItem)
FROM yourtable
GROUP BY FldItem
ORDER BY 1
Stephen Howe
.
- Follow-Ups:
- References:
- Prev by Date: Re: How to summarize recordset...Select Distinct alternative?
- Next by Date: Re: How to summarize recordset...Select Distinct alternative?
- Previous by thread: Re: How to summarize recordset...Select Distinct alternative?
- Next by thread: Re: How to summarize recordset...Select Distinct alternative?
- Index(es):
