Perfect! Thanks!


>Try

SELECT ;
>		UserId, ;
>		COUNT(*) AS NumSpots, ;
>		COUNT(DIST invoiceid) AS Invoices, ;		
>		SUM(Gross) AS TotalGross, ;
>		SUM( IIF(Status = 'D', 1, 0)) AS Discrep, ;
>		SUM( IIF(Status = 'R', 1, 0)) AS Reconciled ;
>	FROM Commits ;	
>	GROUP BY 1
>
>

>
>>I need to pull invoice records from a table called 'Commits'.
>>I need to following data, rolled up by column UserId:
>>
>>

>>UserId       - Id of the user who created the record
>>NumSpots     - Equal to the # records retreived for the user
>># Invoices   - Would be the same as 'select disticnt invoiceid where userid =...'
>>Total Gross  - SUM of the Gross column, by user
>>Discrep      - Total number of records with Status = 'D', by user
>>Reconciled   - Total number of records with Status = 'R', by user
>>